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

HIVE View 2.0 problem executing select and insert statements

Explorer

Hello, i am newbie to sandbox and i just started learning tutorial to use Hortonworks sandbox i installed it in my PC windows 10, with vmware PRO 14, the configuration all went well, i can successfully login to Ambari with maria_dev, and can load truck data files in FileView interface of Ambari , then i use HIVE VIEW 2.0 where i create the table drivers from temp_drivers table, it all went ok but the insert query that insert record from temp_drivers table to drivers table takes too long to execute and is ended with error, can anyone explain the reason , also the select statement that limit only 10 record is also not executing, Please your help is highly appreciated as i am stuck with it

5 REPLIES 5

Super Mentor

@Sana Faraz

It might be due to resources limitations. May be you can try stopping some unwanted services that you are not testing currently like (Oozie/Spark/Zeppelin ...etc). Put the unwanted services in Maintenance mode and then restart the ambari server freshly.

If needed then please try restarting the HIve Services as well. Then try accessing the HiveView 2.0.

If you still see any error then please share the following logs sothat we can see the error to findut the cause of failure.

[root@sandbox ~]# ls -l /var/log/ambari-server/hive20-view/hive20-view.log 
[root@sandbox ~]# ls -l /var/log/ambari-server/ambari-server.log 

.

Explorer

how can i stop/Maintenance mode the unwanted service that you mentioned

Super Mentor

@Sana Faraz

Login to ambari UI and then navigate to following: [ http://localhost:8080 ]

Ambari UI --> Oozie --> "Services Actions" (top right corner of the UI) --> Click on "Stop"

Ambari UI --> Oozie --> "Services Actions" (top right corner of the UI) --> Click on "Turn On Maintenance Mode"

.

Repeat the same steps for other unwanted services. Then later when you want to test those services then please "Start" them and the turn off the maintenance mode.

Explorer

57386-img1.png

57387-img2.png

i followed the same procedure and type the query in HIVE Query tab as select count(*) from temp_drivers table but still the query keeps executing for long i am attaching the screen shots

Expert Contributor

Take a look at troubleshooting section of learning the ropes tutorial:

https://hortonworks.com/tutorial/learning-the-ropes-of-the-hortonworks-sandbox/#appendix-b-troublesh...