You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chi Lang (JIRA)" <ji...@apache.org> on 2015/06/26 17:30:05 UTC
[jira] [Created] (DRILL-3393) Quotes not being recognized in tab
delimited (tsv) files
Chi Lang created DRILL-3393:
-------------------------------
Summary: Quotes not being recognized in tab delimited (tsv) files
Key: DRILL-3393
URL: https://issues.apache.org/jira/browse/DRILL-3393
Project: Apache Drill
Issue Type: Bug
Components: Storage - Text & CSV
Affects Versions: 1.0.0
Reporter: Chi Lang
Assignee: Steven Phillips
Priority: Minor
Drill doesn't seem to recognise quotes in tsv, while working fine for csv files.
For example, given the following files
test.tsv
-------
foobar bar
"aa" "bc"
-------
test.csv
----------
foobar,bar
"aa","bc"
----------
I get these results:
0: jdbc:drill:zk=local> select columns[0], columns[1] from dfs.`test.csv`;
+---------+---------+
| EXPR$0 | EXPR$1 |
+---------+---------+
| foobar | bar |
| aa | bc |
+---------+---------+
2 rows selected (0.259 seconds)
0: jdbc:drill:zk=local> select columns[0], columns[1] from dfs.`test.tsv`;
+----------+---------+
| EXPR$0 | EXPR$1 |
+----------+---------+
| foobar | bar |
| aa" "bc | null |
+----------+---------+
2 rows selected (0.122 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)