Hi All,
I am trying to execute hive commands on json file using
jsonserde's,but I am always getting null values ,but not actual data.
I have used serde's provided in
"code.google.com/p/hive-json-serde/downloads/list" link. I have tried
multiple ways but all of the attempts were not successful. Ple
Try putting " -e "use db_stage;show tables" in a file instead and do
bl -f
HTH
Dr Mich Talebzadeh
LinkedIn
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
Sybase ASE 15 Gold Medal Award 2008
A Winning Strategy: Running the most Critical Fina
My command is:
*beeline -u
"jdbc:hive2://:10001/;principal=hive/@http://a.b.c.com>>?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice"
-e "use db_stage;show tables"*
*Error:*
scan complete in 4ms
Connecting to jdbc:hive2://:10001/;principal=hive/@<
a.b.c.com
>?hive.serv
Correction
That bl should read (no ,)
bl='beeline -u jdbc:hive2://rhes564.hedani.co:10010/default
org.apache.hive.jdbc.HiveDriver -n -p -i
/home//dba/bin/hive_on_spark_init.hql'
Dr Mich Talebzadeh
LinkedIn
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCd
That should work. No need for \
bl -e "use test;show tables"
No rows affected (0.026 seconds)
++--+
|tab_name|
++--+
| t |
| txtest |
++--+
My bl is aliased as below
bl='beeline -u jdbc:hive2://rhes56
Thanks Maciek !
Another issue is I am using *Hive 0.13.0.2.1.7.0-784 * and *Beeline version
0.13.0.2.1.7.0-784 by Apache Hive.*
I am able to execute:
*hive -e "use db_test; show tables"*
But while executing same in beeline gives error:
*beeline -u "" -e **"use db_test; sh
