Simeon Simeonov created SPARK-11522:
---------------------------------------
Summary: input_file_name() returns "" for external tables
Key: SPARK-11522
URL: https://issues.apache.org/jira/browse/SPARK-11522
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.5.1
Reporter: Simeon Simeonov
Given an external table definition where the data consists of many CSV files,
{{input_file_path()}} returns empty strings.
Table definition:
{code}
CREATE EXTERNAL TABLE external_test(page_id INT, impressions INT)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
"separatorChar" = ",",
"quoteChar" = "\"",
"escapeChar" = "\\"
)
LOCATION 'file:///Users/sim/spark/test/external_test'
{code}
Query:
{code}
sql("SELECT input_file_name() as file FROM external_test").show
{code}
Output:
{code}
+----+
|file|
+----+
| |
| |
...
| |
+----+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
