Advertisement
Guest User

Untitled

a guest
Apr 13th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. beeline> !connect jdbc:hive2://localhost:10000
  2. Connecting to jdbc:hive2://localhost:10000
  3. Enter username for jdbc:hive2://localhost:10000:
  4. Enter password for jdbc:hive2://localhost:10000:
  5. Connected to: Spark SQL (version 1.6.0)
  6. Driver: Spark Project Core (version 1.6.0)
  7. Transaction isolation: TRANSACTION_REPEATABLE_READ
  8. 0: jdbc:hive2://localhost:10000> CREATE TEMPORARY TABLE test USING org.apache.spark.sql.parquet OPTIONS ( path "someFile" );;
  9. +---------+--+
  10. | Result |
  11. +---------+--+
  12. +---------+--+
  13. No rows selected (1.12 seconds)
  14. 0: jdbc:hive2://localhost:10000> select count (*Display all 560 possibilities? (y or n)
  15. 0: jdbc:hive2://localhost:10000> select count (*) from test;
  16. +----------+--+
  17. | _c0 |
  18. +----------+--+
  19. | 1000000 |
  20. +----------+--+
  21. 1 row selected (1.714 seconds)
  22. 0: jdbc:hive2://localhost:10000> select count (*) from test;
  23. +----------+--+
  24. | _c0 |
  25. +----------+--+
  26. | 1000000 |
  27. +----------+--+
  28. 1 row selected (0.167 seconds)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement