question Re: Queries in Zeppelin in Archives of Support Questions (Read Only)

Queries in Zeppelin

TimothySpann — Wed, 03 Aug 2016 00:37:30 GMT

This query works in Ambari Hive View and Zeppelin SQL view

SELECT sentiment, CASE WHEN LENGTH(location) > 0 THEN substring(location,0,10) ELSE 'UNK' END AS location, COUNT(*)  as num
from tweetsbi
where country is not null and ts is not null and
tweet_id is not null and sentiment is not null and 
location is not null and location != '' and country 
!= '' 
GROUP BY sentiment, location
order by num desc, sentiment

It does not work in Hive view in Zeppelin.

This is on HDP 2.4.2 Sandbox.

Re: Queries in Zeppelin

abajwa — Wed, 03 Aug 2016 01:02:25 GMT

@Timothy Spann: Can you try @nmaillard's suggestion from here?

Re: Queries in Zeppelin

sunile_manjee — Wed, 03 Aug 2016 01:31:42 GMT

Another work around which worked for me is havimg hive interpretur as first one called out in youe bind. good friend binu matthew found that one

Re: Queries in Zeppelin

claudia — Fri, 09 Jun 2017 15:11:06 GMT

@timothy span did substring function really worked with sql interpreter on Zeppelin? or did you some change to the interpreter? Thank you!