@Artem Ervits Here are steps to reproduce in 1.4.1 sandbox. Still getting the issue, too many characters for a comment. Thoughts? STEPS: $pyspark sqlContext.sql("create table names(name string, age int) row format delimited fields terminated by ',' stored as textfile TBLPROPERTIES('skip.header.line.count'='1')")
sqlContext.sql("LOAD DATA INPATH '/user/root/test.txt' overwrite into table names")
sqlContext.sql("Select count(*) from names").show()
3
sqlContext.sql("Select * from names").show()
+-----+-----+
| name| age |
| name| null|
| aaa| 1|
| bbb| 2| hive> select count(*) from names;
2
INPUT FILE: "test.txt", with contents:
name,age
aaa,1
bbb,2
... View more
