question Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned in Archives of Support Questions (Read Only)

In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

s_panigrahi239 — Fri, 19 Feb 2016 18:17:14 GMT

Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

aervits — Fri, 19 Feb 2016 19:04:22 GMT

@sasmita panigrahi please provide logs in the Hive directory. Typically logs are in /var/log/ with name of service you are using

Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

s_panigrahi239 — Fri, 19 Feb 2016 19:44:55 GMT

i am afraid i am not able to see any log files under app-logs/hive/logs with today's date, where as i can find many log files on 16th of feb date ,those log files i m attaching below

application-1455583905462-0003.zip

Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

nsabharwal — Fri, 19 Feb 2016 19:52:28 GMT

@sasmita panigrahi Please run the job again, it will give you app id

then run

yarn log -applicationid appid

Also, How are you loading the data?

Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

s_panigrahi239 — Fri, 19 Feb 2016 21:14:44 GMT

my error got resolved which was due to naming conflict,,thank you so much for the fast response

Re: In the visualize website click stream data data project , when ever i am trying to load the data in to the hive table it is showing status succeded-query submitted , but when i tried to run select * from table tablename limit 100 -nothing is returned

aervits — Fri, 19 Feb 2016 21:19:36 GMT

@sasmita panigrahi

take a look in /var/log/hive on the server that has your hive server installation. The logs you'd sent are not valid.