Can not create a Path from an empty string when using hive 3

Asked Jul 21 '21 at 07:23

Active Jul 21 '21 at 07:23

Viewed 304 times

I run the following hive sql on hive 3, and it throw error of Can not create a Path from an empty string, but the same sql works on hive 2, anyone know why ? Thanks

CREATE TABLE IF NOT EXISTS people_csv (id int, name string) 
PARTITIONED by (dt string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

asked Jul 21 '21 at 07:23

zjffdu

25,496
45
109
159

may be you need to add a `LOCATION` because default location is not defined in hive3 – Koushik Roy Jul 21 '21 at 08:41
1

Read this question: https://stackoverflow.com/a/65001452/2700344 – leftjoin Jul 21 '21 at 12:03

Can not create a Path from an empty string when using hive 3

0 Answers0