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) <warwit...@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, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@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
