Treasure Data's primary idea portal. 

Submit your ideas & feature requests directly to our product requirements team! We look forward to hearing from you.

TD TABLE:EXPORT supports json.gz and line-json.gz formats, but TD QUERY doesn't


We're making automation scripts that import the data into TD or export it out. We're using your TD CLI utility for most of the tasks.

Our pipeline works best with the line-json.gz format. Unfortunately the TD CLI utility supports that format for Table:Export, but not for the Query command. We can export the data to S3, but it can't save to the line-json.gz format.

Why is that? Surely, once you have created the dataset export function for line-json.gz and it works with Table:Export it should also work with Query or any other command. How come Query can export to different formats that Export?

I really like your service and utilities, but don't understand this inconsistency.

Best regards,


  • Guest
  • Apr 26 2017
  • Guest commented
    May 2, 2017 16:09

    Just to clear things up, shouldn't TABLE:EXPORT and QUERY support identical output formats?