Re: Only External tables can have an explicit location

2017-01-25 Thread Gopal Vijayaraghavan
> Error 40003]: Only External tables can have an explicit location … > using hive 1.2. I got this error. This was definitely not a requirement > before Are you using Apache hive or some vendor fork? Some BI engines demand there be no aliasing for tables, so each table needs a unique

Only External tables can have an explicit location

2017-01-25 Thread Edward Capriolo
Error 40003]: Only External tables can have an explicit location using hive 1.2. I got this error. This was definitely not a requirement before Why way this added? External table ONLY used to be dropping the table will not drop the physical files.