[
https://issues.apache.org/jira/browse/CALCITE-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16720800#comment-16720800
]
Julian Hyde commented on CALCITE-2735:
--------------------------------------
Your facts are slightly incorrect. While MySQL supports {{LOAD DATA}} in SQL,
Oracle does not support {{LOAD DATA}} in SQL, only in
[SQLLoader|https://stackoverflow.com/questions/8953110/load-data-infile-equivalent-in-oracle]
scripts.
There's no official policy for what we should accept into the DDL parser, but I
think we should be aiming for a common subset - that is, commands supported by
two or three unrelated databases - and I don't think this feature passes that
threshold. Even if we don't add it to our DDL parser, it should be fairly
straightforward to add it to your own variant of the parser, using the fmpp
templates we provide. If it is not straightforward, we should extend the
template system.
> support load data of dml statement
> ----------------------------------
>
> Key: CALCITE-2735
> URL: https://issues.apache.org/jira/browse/CALCITE-2735
> Project: Calcite
> Issue Type: Improvement
> Components: server
> Affects Versions: 1.17.0, 1.18.0
> Reporter: ambition
> Assignee: Julian Hyde
> Priority: Minor
> Fix For: 1.18.0
>
>
> support load data statement, like mysql or apache hive, dml sql is:
> {code:java}
> LOAD DATA [LOCAL] INFILE 'filePath' [OVERWRITE] INTO TABLE tableName
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
