Re: beeline/hiveserver2 + logging

2016-08-09 Thread Gopal Vijayaraghavan
> not get the progress messages back until the query finishes which >somewhat defeats the purpose of interactive usage. That happens entirely on the client side btw. So to avoid a hard sleep() + check loop causing pointless HTTP traffic, HiveServer2 now does a long poll on the server side. hive.

Re: beeline/hiveserver2 + logging

2016-08-09 Thread Stephen Sprague
finishing this thread off... yes, it worked to a degree. by setting hive.async.log.enabled=false one does get the job_id and the tracking url returned to the client before the job is launched on the cluster. So that part is good. However, one does not get the progress messages back until the quer

Re: beeline/hiveserver2 + logging

2016-08-09 Thread Stephen Sprague
well, well. i just found this: https://issues.apache.org/jira/browse/HIVE-14183 seems something changed between 1.2.1 and 2.1.0. i'll see if the Rx as prescribed in that ticket does indeed work for me. Thanks, Stephen. On Tue, Aug 9, 2016 at 5:12 PM, Stephen Sprague wrote: > hey guys, > try

?????? hiveserver2 start hang

2016-08-09 Thread ??????
Mich , I started Hive 2.1.0 by $HIVE_HOME/bin/hiveserver2 --hiveconf hive.root.logger=DEBUG,console 1/10010 port was not used. Actually, I successfully started hive 2.1.0 in another hadoop env. BUT, I havn't started it in this env . This env has kerberos auth which I think even so, so

beeline/hiveserver2 + logging

2016-08-09 Thread Stephen Sprague
hey guys, try as i might i cannot seem to get beeline (via jdbc) to log information back from hiveserver2 like job_id, progress and that kind of information (similiar to what the local beeline or hive clients do.) i see this ticket that is closed: https://issues.apache.org/jira/browse/HIVE-7615 wh

Error message "Read past end of RLE integer from compressed stream Stream for column"

2016-08-09 Thread Tale Firefly
Hello ! I have an HDP 2.2.4.2.(it has normally hive 0.14.0). I have a ORC table with multiple fields : ### CREATE TABLE `table1`( `field1` varchar(10), `field2` varchar(10), `field3` date, `field4` varchar(8), `field5` varchar(64) PARTITIONED BY ( `year` string, `month` string, `d

Re: hiveserver2 start hang

2016-08-09 Thread Mich Talebzadeh
what command did you use to start hiveserver2? $HIVE_HOME/bin/hiveserver2 & is the port 1 used? netstat -alnp|egrep 'Local|10010' HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

hiveserver2 start hang

2016-08-09 Thread ??????
I failed to start hiveserver2. After turned the log on, I caught: BIGL6TMP:/etc # $HIVE_HOME/bin/hiveserver2 --hiveconf hive.root.logger=DEBUG,console SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/lib/apache-hive-2.1.0-bin/lib/log4j-slf4j-impl-2.4.1.j

Re: hive session drops tables when restarted

2016-08-09 Thread Sumit Khanna
Hello Mich, Well there was a little problem, as of now it asks for adding mysql connector to classpath. I simply added the mysql connector jars to /opt/hive/lib/ I believe that should have sufficed isnt it? ie. mysql-metadata-storage-0.9.1.1.tar.gz mysql-connector-java-5.1.39.tar.gz it still gi