Subscribe Bookmark RSS Feed

Hive SQL Query builder - Performance issues

scott_87

Community Trekker

Joined:

Feb 22, 2013

Hi Guys,

I'm running JMP 13 and have used the cloudera hive ODBC driver to sucesfully connect the JMP query builder to our hadoop hive server. I am able to view the tables ok, but once i click on one of the tables it automatically sends a "select * from table" query to the hadoop cluster which completely hangs up my JMP due to the enormous size of the table its trying to pull without my consent. 

Is there a way to turn this off? 

I have attached a snapshot of my query builder preferences below:

 

Capture12343214.PNG

1 REPLY
ih

Community Trekker

Joined:

Sep 30, 2016

@Eric_Hill gave me a solution here that might work for you.