RE: Hive table for a single file: CREATE/ALTER TABLE differences

2017-01-25 Thread Markovitz, Dudu
Wow. This is gold. Dudu From: Dmitry Tolpeko [mailto:dmtolp...@gmail.com] Sent: Wednesday, January 25, 2017 6:47 PM To: user@hive.apache.org Subject: Hive table for a single file: CREATE/ALTER TABLE differences ​ ​I accidentally noticed​​ one feature: (it is well know ​n​ that in CREATE TABLE

Hive table for a single file: CREATE/ALTER TABLE differences

2017-01-25 Thread Dmitry Tolpeko
​ ​I accidentally noticed​​ one feature: (it is well know ​n​ that in CREATE TABLE you must specify a directory for the table LOCATION otherwise you get: "Can't make directory for path 's3n://dir/file' since it is a file.") But at the same time, ALTER TABLE SET LOCATION 's3n://dir/file' works fine