Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Re: Partition not displaying in the browser


Copy link to this message
-
Re: Partition not displaying in the browser
Sai Sai 2013-03-08, 03:51
Many Thanks for your help Venkatesh.

I have verified the partition exists and also the data displays successfully in the partition when i execute the select in the console.

But it does not appear in the web browser.

I have verified multiple time the path i have given and is given below:

Here is the first partition i have created and viewing successfully in both console & web browser:

ALTER TABLE dividends ADD PARTITION(exchange = 'NASDAQ', symbol = 'AAPL') LOCATION '/home/satish/data/dividends/input/plain-text/NASDAQ/AAPL';

LOAD DATA LOCAL INPATH '/home/satish/data/dividends/input/plain-text/NASDAQ/AAPL/dividends.csv' INTO TABLE dividends Partition(exchange='NASDAQ',symbol='AAPL');

Here is the one i can view only in the console but not in the browser:

        ALTER TABLE dividends ADD PARTITION(exchange = 'NASDAQ', symbol = 'INTC') LOCATION '/home/satish/data/dividends/input/plain-text/NASDAQ/INTC';

        LOAD DATA LOCAL INPATH '/home/satish/data/dividends/input/plain-text/NASDAQ/INTC/dividends.csv' INTO TABLE dividends Partition(exchange='NASDAQ',symbol='INTC');
When i run the command:
select * from dividends where exchange='NASDAQ' and symbol='INTC';
I succesfully see the data.
I am wondering if it is  possible to bounce/restart the server with any command or
is it possible to look into the hive metadata directly using a command.
Any help is appreciated.
Thanks
Sai

________________________________
 From: Venkatesh Kavuluri <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Thursday, 7 March 2013 1:44 PM
Subject: RE: Partition not displaying in the browser
 

 
The partitions info you see on 'show partitions' is fetched from Hive metadata tables. The reason you are not seeing the path you are expecting might be either 
1) the path got deleted after the data load (do a simple select and verify you see some data) or
2) you have loaded the data from some other path to this partition  

-
Venkatesh

________________________________
Date: Fri, 8 Mar 2013 00:54:17 +0800
From: [EMAIL PROTECTED]
Subject: Re: Partition not displaying in the browser
To: [EMAIL PROTECTED]
I get this ouput for:

hive> show partitions dividends;
OK
partition
exchange=NASDAQ/symbol=AAPL
exchange=NASDAQ/symbol=INTC
Time taken: 0.133 seconds

But when i navigate to my browser folder the partition INTC is not displayed even after refreshing it a bunch of times, any suggestions will be appreciated:
*************************
Contents of directory /home/satish/data/dividends/input/plain-text/NASDAQ
________________________________
Goto :
________________________________
Go to parent directory

Name
 Type
 Size
 Replication
 Block Size
 Modification Time
 Permission
 Owner
 Group
 
AAPL
 dir
 
 
 
 2013-03-07 08:46
 rwxr-xr-x
 satish
 supergroup
 
Go back to DFS home
________________________________
 
Local logs
Any suggestions will be appreciated.
Thanks
Sai