Zeppelin Hive Example Notebook.

[๏̯͡๏ <ÐΞ€ρ@Ҝ>, de...@gmail.com]

Could someone please share a example notebook that describes
1) Loading of sample dataset into Hive
2) Run Hive queries.

-- 
Deepak

Re: Zeppelin Hive Example Notebook.

[๏̯͡๏ <ÐΞ€ρ@Ҝ>, de...@gmail.com]

I am unable to write Hive statements to load data into Hive table from HDFS.

In HDFS i have 5 files in gz format. When uncompressed its in CSV format.
Is it possible to load the HDFS compressed file into Hive tables . I tried
multiple versions and could not get it working.




drop table guidsess
select * from guidsess
CREATE TABLE guidsess(guid String, sessionKey String, sessionStartDate
String, siteId String, eventCount String, browser String, browserVersion
String, operatingSystem String, experimentChannel String, deviceName
String)   ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n'
LOAD DATA INPATH '/user/zeppelin/guidsess/2015/08/05/part-m-00001.gz' INTO
TABLE guidsess
select * from guidsess;


Please suggest ?

Also i was not able to run multiple hive statements in on paragraph. Each
time i had to copy and replace one line (statement) at a time.  With ; at
end of each line, i get syntax error. Please suggest.


My Hive installation is correct, i can see show functions, show tables.


On Sun, Aug 9, 2015 at 8:43 PM, 김영우 (Youngwoo Kim) <wa...@gmail.com>
wrote:

> Basically, Hive interpreter is a JDBC client for Hive Server. So before
> you are getting started, make sure your Hive server is running.
>
> Then, you should configure the URL for Hive server on interpreter's
> configurations. Using Hive interpreter is straightforward. like below:
> %hive
> show tables
> show functions
> select ... from tbl
> create table ... as select ...
> (whatever, valid hive SQL...)
>
> HTH,
> Youngwoo
>
> On Mon, Aug 10, 2015 at 2:23 AM, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@gmail.com>
> wrote:
>
>> Could someone please share a example notebook that describes
>> 1) Loading of sample dataset into Hive
>> 2) Run Hive queries.
>>
>> --
>> Deepak
>>
>>
>


-- 
Deepak

Re: Zeppelin Hive Example Notebook.

["김영우 (Youngwoo Kim)" <wa...@gmail.com>]

Basically, Hive interpreter is a JDBC client for Hive Server. So before you
are getting started, make sure your Hive server is running.

Then, you should configure the URL for Hive server on interpreter's
configurations. Using Hive interpreter is straightforward. like below:
%hive
show tables
show functions
select ... from tbl
create table ... as select ...
(whatever, valid hive SQL...)

HTH,
Youngwoo

On Mon, Aug 10, 2015 at 2:23 AM, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@gmail.com> wrote:

> Could someone please share a example notebook that describes
> 1) Loading of sample dataset into Hive
> 2) Run Hive queries.
>
> --
> Deepak
>
>