Creation of a partitioned external table with hive: no data available

Question

I have the following file on HDFS:

I create the structure of the external table in Hive:

CREATE EXTERNAL TABLE google_analytics(
  `session` INT)
PARTITIONED BY (date_string string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/flumania/google_analytics';

ALTER TABLE google_analytics ADD PARTITION (date_string = '2016-09-06') LOCATION '/flumania/google_analytics';

After that, the table structure is created in Hive but I cannot see any data:

Since it's an external table, data insertion should be done automatically, right?

Answer 1

your file should be in this sequence.

int,string

here you file contents are in below sequence

string, int

change your file to below.

86,"2016-08-20"
78,"2016-08-21"

It should work.
Also it is not recommended to use keywords as column names (date);