[jira] [Commented] (CALCITE-2735) support load data of dml statement

2018-12-13 Thread ambition (JIRA) 


[ 
https://issues.apache.org/jira/browse/CALCITE-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16720820#comment-16720820
 ] 

ambition commented on CALCITE-2735:
---

ok

> 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)

[jira] [Commented] (CALCITE-2735) support load data of dml statement

2018-12-12 Thread ambition (JIRA) 


[ 
https://issues.apache.org/jira/browse/CALCITE-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16719653#comment-16719653
 ] 

ambition commented on CALCITE-2735:
---

Mysql and Oracle are the same, but different from postgresql，Which command is 
the user's habit of using or which command is preferred by the user?

> 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)

[jira] [Commented] (CALCITE-2735) support load data of dml statement

2018-12-12 Thread Julian Hyde (JIRA) 


[ 
https://issues.apache.org/jira/browse/CALCITE-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16719276#comment-16719276
 ] 

Julian Hyde commented on CALCITE-2735:
--

It seems that every database has its own load command, and frankly I don't like 
any of them. What's wrong with {code}INSERT INTO tableName SELECT ... FROM 
TABLE(FileAdapter('filePath')){code}

> 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)

[jira] [Commented] (CALCITE-2735) support load data of dml statement

2018-12-11 Thread ambition (JIRA) 


[ 
https://issues.apache.org/jira/browse/CALCITE-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16718390#comment-16718390
 ] 

ambition commented on CALCITE-2735:
---

github [PR964|https://github.com/apache/calcite/pull/964]

> 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)