Created 05-01-2016 02:18 AM
executing this simple "create table" from tutorial section 5.b.2:
CREATE TABLE events STORED AS ORC AS SELECT driverid, city, state FROM geolocation;
hangs and doesn't even seem to start. get log msg "Tez session hasn't been created yet" and nothing more. simply selecting the data (no create table) works and responds instantly.
??
Created 05-01-2016 02:52 AM
Please upload or paste if you see any stacktrace from /var/log/hive/hiveserver2.log. Surprising that select works but not CTAS. hiveserver2.log could provide some insights.
Created 05-02-2016 02:51 PM
thanks. No stack traces noted in the log files. It seems that some but not all hive activity is getting hung up. I can select from tables, but cannot create (as noted above). additionally, the hive cli hangs up (as reported separately).
Created 05-02-2016 03:04 PM
I restarted ambari server and now it is working. any ideas of what may have caused the hangup to begin with welcome.
Created 05-02-2016 03:13 PM
If select worked and not CTAS, I can only think of metastore SQL engine not allowing writes and read working fine. But that should come in hiveserver2.log if that happens.