Cloudera Community
stevens_yeungha
user rank
Explorer

Re: ​Hive queries blocked - Tez always shows runni...

by Explorer in Support Questions
‎02-07-2018 06:43 AM
‎02-07-2018 06:43 AM
I'm having the same problem, I killed some jobs, but tez UI saus some of them are still running; no App ID or DAG ID. Query was launched from Hive HDP 2.6.0.3-8 YARN 2.7.3 Tez 0.7.0 ... View more

Re: Beeline CLI parameters (hivevar) not evaluatin...

by Explorer in Support Questions
‎06-16-2017 12:13 PM
‎06-16-2017 12:13 PM
Thanks @mqureshi, however it gives me the same thing; beeline -u jdbc:hive2:// --hivevar rdate=112211 -e "select 9${hivevar:rdate}9" Connecting to jdbc:hive2:// Connected to: Apache Hive (version 1.2.1000.2.5.0.0-1245) Driver: Hive JDBC (version 1.2.1000.2.5.0.0-1245) Transaction isolation: TRANSACTION_REPEATABLE_READ OK +------+--+ | _c0 | +------+--+ | 99 | +------+--+ 1 row selected (4.268 seconds) Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive Closing: 0: jdbc:hive2:// I'm on HDP 2.5 btw. Test server, 1 node. ... View more

Re: Beeline CLI parameters (hivevar) not evaluatin...

by Explorer in Support Questions
‎06-16-2017 12:13 PM
‎06-16-2017 12:13 PM
Made it to work. Had to use the full database path, i.e. Doesnt work: -u jdbc:hive2:// Works: -u jdbc:hive2://localhost:10000 ... View more

Re: Beeline CLI parameters (hivevar) not evaluatin...

by Explorer in Support Questions
‎06-16-2017 12:13 PM
‎06-16-2017 12:13 PM
Managed to get hive to substitute the variable, but not beeline; hive --hivevar rdate=112211 -e 'select 9${hivevar:rdate}9' Logging initialized using configuration in file:/etc/hive/2.5.0.0-1245/0/hive-log4j.properties OK 91122119 Time taken: 3.76 seconds, Fetched: 1 row(s) ... View more

Re: Beeline CLI parameters (hivevar) not evaluatin...

by Explorer in Support Questions
‎06-16-2017 12:13 PM
‎06-16-2017 12:13 PM
beeline -u jdbc:hive2:// --hivevar rdate=112211 -e "set rdate" Returns rdate is underfined, but hive --hivevar rdate=112211 -e "set rdate" returns: Logging initialized using configuration in file:/etc/hive/2.5.0.0-1245/0/hive-log4j.properties rdate=112211 However, using the variable in hive still does not evaluate: hive --hivevar rdate=112211 -e "select 9${hivevar:rdate}9" Logging initialized using configuration in file:/etc/hive/2.5.0.0-1245/0/hive-log4j.properties OK 99 Time taken: 3.178 seconds, Fetched: 1 row(s) ... View more

Beeline CLI parameters (hivevar) not evaluating

by Explorer in Support Questions
‎06-16-2017 12:13 PM
‎06-16-2017 12:13 PM
Hello, I've been struggling with parameters in command line. Parameters work in interactive shell but I cannot figure out what is wrong. This is the code I'm running. Output should be 9911221199, but only 99 is displayed. [hive@bitest ~]$ beeline -u jdbc:hive2:// --hivevar rdate=112211 -e "select 9${hivevar:rdate}9" Connecting to jdbc:hive2:// Connected to: Apache Hive (version 1.2.1000.2.5.0.0-1245) Driver: Hive JDBC (version 1.2.1000.2.5.0.0-1245) Transaction isolation: TRANSACTION_REPEATABLE_READ OK +------+--+ | _c0 | +------+--+ | 99 | +------+--+ 1 row selected (3.818 seconds) Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive Closing: 0: jdbc:hive2:// ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎02-07-2018 06:43 AM
Community Statistics
Member Since ‎05-04-2017 10:00 AM
Last Visited ‎02-07-2018 06:43 AM
Posts 8