Re: removing hdfs table data directory does not throw error in hive

2012-04-24 Thread Nitin Pawar
looks like a good use case created and improvement request https://issues.apache.org/jira/browse/HIVE-2980 On Tue, Apr 24, 2012 at 9:10 AM, Sukhendu Chakraborty < sukhendu.chakrabo...@gmail.com> wrote: > Thanks Nitin. I am aware of what Hive is doing. The question is, is it > okay not return an

Re: removing hdfs table data directory does not throw error in hive

2012-04-23 Thread Sukhendu Chakraborty
Thanks Nitin. I am aware of what Hive is doing. The question is, is it okay not return an error/warning when no data is found since the metadata for the table also contains the data location when you create the table (which creates the hdfs directory as well). So, if somebody erroneously removes t

Re: removing hdfs table data directory does not throw error in hive

2012-04-23 Thread Nitin Pawar
hive table meta data is stored into a meta data store which will retain the table structure and other meta info even if you delete hdfs table directory as its stored in metadata store db. When you do a select * from table; 1) hive checks for table exists in metadata store 2) if table is existing t