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 <vkavul...@outlook.com> To: "user@hive.apache.org" <user@hive.apache.org> 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: saigr...@yahoo.in Subject: Re: Partition not displaying in the browser To: user@hive.apache.org 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
