Hey guys,
sorry to bother you again but i was trying to get tez working with beeline
now (it does work great with the local hive client i might add) so i'm sure
i'm missing something simple.
if i use the 'local' beeline client as such 'beeline -u jdbc:hive2://' tez
works fine but that comes with start up costs just like the hive local
client does so that's what i'm trying to avoid by going through hiveserver2.
* so using this paradigm:
beeline -u 'jdbc:hive2://dwrdevnn1.sv2.truila.com:10001/default;auth=noSasl
sprague nopwd org.apache.hive.jdbc.HiveDriver' <<SQL
set hive.execution.engine=tez;
set mapreduce.framework.name=yarn-tez;
select count(*) from omniture.hit_data where date_key=20160210;
SQL
* things just hang at this point.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
issuing: !connect jdbc:hive2://
dwrdevnn1.sv2.trulia.com:10001/default;auth=noSasl sprague nopwd
org.apache.hive.jdbc.HiveDriver '' ''
Connecting to jdbc:hive2://
dwrdevnn1.sv2.trulia.com:10001/default;auth=noSasl
Connected to: Apache Hive (version 1.2.1)
Driver: Hive JDBC (version 1.2.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Executing command:
set hive.execution.engine=tez;
set mapreduce.framework.name=yarn-tez;
select count(*) from omniture.hit_data where date_key=20160210;
Getting log thread is interrupted, since query is done!
No rows affected (0.067 seconds)
Getting log thread is interrupted, since query is done!
No rows affected (0.003 seconds)
Any recommendations that i need to make to get things to work via HS2?
(engine=mr works w/o issue)
Cheers,
Stephen.