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
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