Sai Sai 2013-03-07, 16:54
Venkatesh Kavuluri 2013-03-07, 21:44
-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.
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
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;
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
Go to parent directory
Go back to DFS home
Any suggestions will be appreciated.