You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Vikas Parashar <pa...@gmail.com> on 2015/01/15 09:36:10 UTC

full query submitted to hiveserver2

Hi,

I have written an application that is contacting with my hive server2. I
just want to check how may queries has been submitted on my hive and full
details about the query. But when i have grep this remote command in my
hiveserver2 logs. I got below information only:

[abc@xyz ~]# cat /var/log/hive/hiveserver2.log | grep -ir --color starting\
command
2015-01-15 07:08:43,695 INFO  [pool-5-thread-16]: ql.Driver
(Driver.java:execute(1197)) - Starting command: use default
2015-01-15 07:08:43,885 INFO  [pool-5-thread-16]: ql.Driver
(Driver.java:execute(1197)) - Starting command: use default
2015-01-15 07:08:44,085 INFO  [pool-4-thread-162]: ql.Driver
(Driver.java:execute(1197)) - *Starting command: select /*+ STREAMTABLE(a)
*/*


When i tired with "yarn application -list", in name part i got only some
info:-

[abc@xyz~]# yarn application -list
15/01/15 08:38:08 INFO impl.TimelineClientImpl: Timeline service address:
http://xyz:8188/ws/v1/timeline/
15/01/15 08:38:09 INFO client.RMProxy: Connecting to ResourceManager at
xyz:8050
Total number of applications (application-types: [] and states: [SUBMITTED,
ACCEPTED, RUNNING]):9
                Application-Id    Application-Name    Application-Type
 User     Queue             State       Final-State       Progress
              Tracking-URL
application_1419417277982_0675 *Select /*+ STREAMTABL...*
lds.allpointoptin(Stage-10)           MAPREDUCE      hive   default
  RUNNING         UNDEFINED         30.45%   http://xyz:38273



I am not getting full query that i have submitted from my applicaton. Can
anybody please put some light on it. From where(any logs location, any
configuration that i have missed), i get full query.

Thanks in Advance!

Rg:
Vicky