Support Questions
Find answers, ask questions, and share your expertise

tutorial 5.b.2 "create table" hangs

Highlighted

tutorial 5.b.2 "create table" hangs

Contributor

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.

??

4 REPLIES 4
Highlighted

Re: tutorial 5.b.2 "create table" hangs

Guru

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.

Re: tutorial 5.b.2 "create table" hangs

Contributor

@Ravi Mutyala

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).

Highlighted

Re: tutorial 5.b.2 "create table" hangs

Contributor

I restarted ambari server and now it is working. any ideas of what may have caused the hangup to begin with welcome.

Highlighted

Re: tutorial 5.b.2 "create table" hangs

Guru

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.