Advertisement
Guest User

Untitled

a guest
Jul 13th, 2016
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.46 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: root
  4. Enter password for jdbc:hive2://localhost:10000: ******
  5. Connected to: Apache Hive (version 1.2.1.2.3.0.0-2557)
  6. Driver: Hive JDBC (version 1.2.1.2.3.0.0-2557)
  7. Transaction isolation: TRANSACTION_REPEATABLE_READ
  8. 0: jdbc:hive2://localhost:10000> select * from iitest1;
  9. +----------------+----------------+----------------+----------------+----------------+----------------+-------------------------------------------------------------------------------------------------------+--+
  10. | iitest1.it1c1 | iitest1.it1c2 | iitest1.it1c3 | iitest1.it1c4 | iitest1.it1c5 | iitest1.it1c6 | iitest1.it1c7 |
  11. +----------------+----------------+----------------+----------------+----------------+----------------+-------------------------------------------------------------------------------------------------------+--+
  12. | 10 | 84000 | A | A | Jonathan | Liu | DGGBNEKBRXLBGKTPAGNPEBOQPIPDUAJLTLMRATQPKFPULKKXKGFFWHGOXFFJFLIFKITHKUQSPNFLQKFUIWHXLSTHPBKLMNUSQWOB |
  13. | 56 | 46000 | F | F | 12345 | 12345 | GIIWEVNSPPRLRDKWIXAUFHVNNJISHUWQADQMLWDBRWKWFSXDDXBGDVFRAWEOBTXXRTMMMAOIQUSQBEUGMQKNHFEBFUQECDAOWJMN |
  14. | 45 | 77000 | K | K | Lucy | King | HJMTHFFEQBSSCHWSGKNHIQFNKMQFNQHQKNTGSRLVFFJXOAFTDARTMVOCWFIAMICLAVCJBWVKQWAPLBEXMLDGGSVVDJXBDTFLQORQ |
  15. | NULL | 77000 | K | K | Lucy | King | HJMTHFFEQBSSCHWSGKNHIQFNKMQFNQHQKNTGSRLVFFJXOAFTDARTMVOCWFIAMICLAVCJBWVKQWAPLBEXMLDGGSVVDJXBDTFLQORQ |
  16. +----------------+----------------+----------------+----------------+----------------+----------------+-------------------------------------------------------------------------------------------------------+--+
  17. 4 rows selected (8.578 seconds)
  18. 0: jdbc:hive2://localhost:10000> select max(it1c1) from iitest1;
  19. INFO : Tez session hasn't been created yet. Opening session
  20.  
  21. hive> select max(IT1C1+IT1C2) from iitest1;
  22. Query ID = root_20160713172448_09ccc9e6-c70d-4e56-b428-e511f62db9a6
  23. Total jobs = 1
  24. Launching Job 1 out of 1
  25. Number of reduce tasks determined at compile time: 1
  26. In order to change the average load for a reducer (in bytes):
  27. set hive.exec.reducers.bytes.per.reducer=<number>
  28. In order to limit the maximum number of reducers:
  29. set hive.exec.reducers.max=<number>
  30. In order to set a constant number of reducers:
  31. set mapreduce.job.reduces=<number>
  32. Starting Job = job_1468423564920_0003, Tracking URL = http://sandbox.hortonworks.com:8088/proxy/application_1468423564920_0003/
  33. Kill Command = /usr/hdp/2.3.0.0-2557/hadoop/bin/hadoop job -kill job_1468423564920_0003
  34. Interrupting... Be patient, this might take some time.
  35. Press Ctrl+C again to kill JVM
  36. killing job with: job_1468423564920_0003
  37. Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
  38. 2016-07-13 17:49:56,510 Stage-1 map = 0%, reduce = 0%
  39. Ended Job = job_1468423564920_0003 with errors
  40. Error during job, obtaining debugging information...
  41. FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
  42. MapReduce Jobs Launched:
  43. Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL
  44. Total MapReduce CPU Time Spent: 0 msec
  45. hive> exit
  46. > ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement