vivek garg   •   almost 8 years ago

Query Techstein data

Hi All,

You all may query data using presto db now.
You need to download CLI from presto db website (https://prestodb.io/docs/current/installation/cli.html) and run following command.
Rename downloaded CLI file to "presto-cli"
java -jar presto-cli --server http://ec2-54-169-130-224.ap-southeast-1.compute.amazonaws.com:8889 --catalog hive --schema default

It is ANSI sql after that.

• 4 comments
• 

  vivek garg   •   almost 8 years ago

  Below data sets are available for querying.
  batch_timestamps
  de_travel
  item_metadata
  order_data

• 

  vivek garg   •   almost 8 years ago

  To download data to your local CSV.

  java -jar presto-cli --server http://ec2-54-169-130-224.ap-southeast-1.compute.amazonaws.com:8889 --catalog hive --schema default --execute "select * from where " > data.csv

• 

  vivek garg   •   almost 8 years ago

  To create table for your local use
  create table as select * from

• 

  vivek garg   •   almost 8 years ago

  Order to item map table is also availble for querying

Comments are closed.