[
https://issues.apache.org/jira/browse/SPARK-11374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15238689#comment-15238689
]
Stephane Maarek commented on SPARK-11374:
-----------------------------------------
any updates on this?
Just some log:
{code}
CREATE SCHEMA IF NOT EXISTS spark_testing;
DROP TABLE IF EXISTS spark_testing.test_csv_2;
CREATE EXTERNAL TABLE `spark_testing.test_csv_2`(
column_1 varchar(10),
column_2 decimal(4,2))
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE LOCATION '/spark_testing_2'
TBLPROPERTIES('serialization.null.format'='', "skip.header.line.count"="1");
select * from spark_testing.test_csv_2;
hive> select * from spark_testing.test_csv_2;
OK
NULL 3
{code}
spark:
{code}
scala> sqlContext.sql("select * from spark_testing.test_csv_2").show()
+--------+--------+
|column_1|column_2|
+--------+--------+
| a| null|
| null| 3.00|
+--------+--------+
{code}
That's a big problem
> skip.header.line.count is ignored in HiveContext
> ------------------------------------------------
>
> Key: SPARK-11374
> URL: https://issues.apache.org/jira/browse/SPARK-11374
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.5.1
> Reporter: Daniel Haviv
>
> csv table in Hive which is configured to skip the header row using
> TBLPROPERTIES("skip.header.line.count"="1").
> When querying from Hive the header row is not included in the data, but when
> running the same query via HiveContext I get the header row.
> "show create table " via the HiveContext confirms that it is aware of the
> setting.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
