大数据上的sql

1. presto sql

1、命令行
查看帮助

 ./presto --server ip:port --catalog hive --schema default  --help

2、例子

./presto --server ip:port --catalog hive --schema default -f  1.sql  ./presto --server ip:port --catalog hive --schema default -e  "show tables " 

https://prestodb.io/docs/current/
http://prestodb-china.com/docs/current/
https://www.facebook.com/notes/facebook-engineering/presto-interacting-with-petabytes-of-data-at-facebook/10151786197628920

2. hive sql

https://cwiki.apache.org/confluence/display/Hive/LanguageManual

3. spark -sql

http://spark.apache.org/sql/
http://spark.apachecn.org/docs/cn/2.2.0/sql-programming-guide.html