[
https://issues.apache.org/jira/browse/PHOENIX-6426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17540355#comment-17540355
]
Sameer Pandit commented on PHOENIX-6426:
----------------------------------------
I see that sqlline add a first line as
{noformat}
Saving all output to "<path_out_file>". Enter "record" with no arguments to
stop it.{noformat}
this is line thats causing issue otherwise I am able to ingest a csv generated
from sqlline via below options
{code:java}
psql.py -q \' -h in-line WEB_USAGE.sql WEB_USAGE.csv{code}
need to define -q for quote char which is single quotes in case of sqlline, and
use first line as headers. I believe changing the behavior of sqlline to not
add the first line in record file is not in scope of this ticket. [~giskender]
would this be considered not a bug? or I am not reproducing it correctly,
[~shahrs87]
> CsvBulkLoadTool should be able to parse the output of sqlline generated csv
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-6426
> URL: https://issues.apache.org/jira/browse/PHOENIX-6426
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Gokcen Iskender
> Assignee: Sameer Pandit
> Priority: Minor
>
> Sqlline generates the csv file in a format that csvbulkloadtool cannot parse.
> [~rushabh.shah] recently hit this problem
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
