[jira] [Closed] (CALCITE-2749) org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 13. Encountered: "`" (96), after : ""

2018-12-20 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition closed CALCITE-2749.
-
Resolution: Fixed

> org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, 
> column 13.  Encountered: "`" (96), after : ""
> ---
>
> Key: CALCITE-2749
> URL: https://issues.apache.org/jira/browse/CALCITE-2749
> Project: Calcite
>  Issue Type: Bug
>  Components: core, server
>Affects Versions: 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Major
>
> Dear all, I use ServerParserTest test sql like as :
> {code:java}
> INSERT INTO `test.db3.tb3` SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 
> UNION ALL (SELECT a * 2, b, c FROM test.db1.tb1)
> {code}
> then occur Exception:
> {code:java}
> java.lang.RuntimeException: Error while parsing SQL: INSERT INTO 
> `test.db3.tb3` SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 UNION ALL 
> (SELECT a * 2, b, c FROM test.db1.tb1)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8503)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.check(SqlParserTest.java:8488)
> at org.apache.calcite.sql.parser.SqlParserTest$Sql.ok(SqlParserTest.java:8686)
> at 
> org.apache.calcite.sql.parser.SqlParserTest.testInsertKInto(SqlParserTest.java:3460)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at 
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at 
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at 
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
> at 
> com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
> at 
> com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
> at 
> com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
> at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
> Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at 
> line 1, column 13. Encountered: "`" (96), after : ""
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:354)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:142)
> at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:156)
> at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:181)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8501)
> ... 25 more
> Caused by: org.apache.calcite.sql.parser.impl.TokenMgrError: Lexical error at 
> line 1, column 13. Encountered: "`" (96), after : ""
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:15511)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:24830)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_416(SqlParserImpl.java:20325)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_2_416(SqlParserImpl.java:10393)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Identifier(SqlParserImpl.java:4405)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.CompoundIdentifier(SqlParserImpl.java:4503)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1195)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:854)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:876)
> at 
>

[jira] [Commented] (CALCITE-2749) org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 13. Encountered: "`" (96), after : ""

2018-12-20 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2749:
---

parser.switchTo("BTID") support，cann't occur this error.

> org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, 
> column 13.  Encountered: "`" (96), after : ""
> ---
>
> Key: CALCITE-2749
> URL: https://issues.apache.org/jira/browse/CALCITE-2749
> Project: Calcite
>  Issue Type: Bug
>  Components: core, server
>Affects Versions: 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Major
>
> Dear all, I use ServerParserTest test sql like as :
> {code:java}
> INSERT INTO `test.db3.tb3` SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 
> UNION ALL (SELECT a * 2, b, c FROM test.db1.tb1)
> {code}
> then occur Exception:
> {code:java}
> java.lang.RuntimeException: Error while parsing SQL: INSERT INTO 
> `test.db3.tb3` SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 UNION ALL 
> (SELECT a * 2, b, c FROM test.db1.tb1)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8503)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.check(SqlParserTest.java:8488)
> at org.apache.calcite.sql.parser.SqlParserTest$Sql.ok(SqlParserTest.java:8686)
> at 
> org.apache.calcite.sql.parser.SqlParserTest.testInsertKInto(SqlParserTest.java:3460)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at 
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at 
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at 
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
> at 
> com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
> at 
> com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
> at 
> com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
> at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
> Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at 
> line 1, column 13. Encountered: "`" (96), after : ""
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:354)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:142)
> at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:156)
> at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:181)
> at 
> org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8501)
> ... 25 more
> Caused by: org.apache.calcite.sql.parser.impl.TokenMgrError: Lexical error at 
> line 1, column 13. Encountered: "`" (96), after : ""
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:15511)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:24830)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_416(SqlParserImpl.java:20325)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_2_416(SqlParserImpl.java:10393)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Identifier(SqlParserImpl.java:4405)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.CompoundIdentifier(SqlParserImpl.java:4503)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1195)
> at 
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:854)
> at 
>

[jira] [Created] (CALCITE-2749) org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 13. Encountered: "`" (96), after : ""

2018-12-19 Thread ambition (JIRA) 
ambition created CALCITE-2749:
-

 Summary: org.apache.calcite.sql.parser.SqlParseException: Lexical 
error at line 1, column 13.  Encountered: "`" (96), after : ""
 Key: CALCITE-2749
 URL: https://issues.apache.org/jira/browse/CALCITE-2749
 Project: Calcite
  Issue Type: Bug
  Components: core, server
Affects Versions: 1.17.0
Reporter: ambition
Assignee: Julian Hyde


Dear all, I use ServerParserTest test sql like as :
{code:java}
INSERT INTO `test.db3.tb3` SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 
UNION ALL (SELECT a * 2, b, c FROM test.db1.tb1)
{code}
then occur Exception:
{code:java}
java.lang.RuntimeException: Error while parsing SQL: INSERT INTO `test.db3.tb3` 
SELECT d * 2, e, g FROM test.db2.tb2 WHERE d < 3 UNION ALL (SELECT a * 2, b, c 
FROM test.db1.tb1)

at 
org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8503)
at 
org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.check(SqlParserTest.java:8488)
at org.apache.calcite.sql.parser.SqlParserTest$Sql.ok(SqlParserTest.java:8686)
at 
org.apache.calcite.sql.parser.SqlParserTest.testInsertKInto(SqlParserTest.java:3460)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at 
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
at 
com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
at 
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at 
line 1, column 13. Encountered: "`" (96), after : ""
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:354)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:142)
at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:156)
at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:181)
at 
org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:8501)
... 25 more
Caused by: org.apache.calcite.sql.parser.impl.TokenMgrError: Lexical error at 
line 1, column 13. Encountered: "`" (96), after : ""
at 
org.apache.calcite.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:15511)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:24830)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_416(SqlParserImpl.java:20325)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_2_416(SqlParserImpl.java:10393)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.Identifier(SqlParserImpl.java:4405)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.CompoundIdentifier(SqlParserImpl.java:4503)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1195)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:854)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:876)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:198)
at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:148)
... 27 more
{code}
and use calcite-core model SqlParserTest also occur this error,  is parser not 
support or I config has error?

 thanks.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[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] [Closed] (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:all-tabpanel
 ]

ambition closed CALCITE-2735.
-
Resolution: Fixed

> 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] [Updated] (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:all-tabpanel
 ]

ambition updated CALCITE-2735:
--
Description: 
support load data statement, like mysql or apache hive, dml sql is:
{code:java}
LOAD DATA [LOCAL] INFILE 'filePath' [OVERWRITE] INTO TABLE tableName
{code}

  was:
support load data statement, like mysql or apache hive, dml sql is:
{code:java}
LOAD DATA [LOCAL] INFILE 'filepath' [OVERWRITE] INTO TABLE tableName
{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] [Created] (CALCITE-2735) support load data of dml statement

2018-12-11 Thread ambition (JIRA) 
ambition created CALCITE-2735:
-

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

[jira] [Commented] (CALCITE-2663) CREATE FUNCTION and DROP FUNCTION DDL commands

2018-11-18 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2663:
---

very good.  (y)   
{code:java}
SqlDropObject.java

case OTHER_DDL:
{code}
should modify as :
{code:java}
case DROP_FUNCTION:
{code}

> CREATE FUNCTION and DROP FUNCTION DDL commands
> --
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (CALCITE-2663) create function and drop function SQL statement

2018-11-15 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2663:
---

ok, I fix [PR #920|https://github.com/apache/calcite/pull/920] based 
branch-1.17 can generate JAR and FILE.  And add function syntax to reference.md

thanks

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Issue Comment Deleted] (CALCITE-2663) create function and drop function SQL statement

2018-11-15 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Comment: was deleted

(was: ok, I fix [PR #920|https://github.com/apache/calcite/pull/920] based 
branch-1.17 can generate JAR and FILE.  And add function syntax to reference.md

thanks)

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-15 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 2:03 PM:
-

ok, I fix [PR #920|https://github.com/apache/calcite/pull/920] based 
branch-1.17 can generate JAR and FILE.  And add function syntax to reference.md

thanks


was (Author: ambition):
ok, I fix [PR #920|https://github.com/apache/calcite/pull/920] based 
branch-1.17.  and add function syntax to reference.md

thanks

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-15 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 1:53 PM:
-

sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR #920|https://github.com/apache/calcite/pull/920] based branch-1.17, so I 
modified PR #913 or PR #920, not modified PR I close pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' JAR = 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 
'file:/path/udf/udf2-0.0.1-SNAPSHOT.jar'), FILE = ('file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 


was (Author: ambition):
sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR #920|https://github.com/apache/calcite/pull/920] based branch-1.17, so I 
modified PR #913 or PR #920, not modified PR I close pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 6:10 AM:
-

ok, I fix [PR #920|https://github.com/apache/calcite/pull/920] based 
branch-1.17.  and add function syntax to reference.md

thanks


was (Author: ambition):
ok, I fix [PR #913|https://github.com/apache/calcite/pull/913] based 
branch-1.16. 

thanks

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 4:43 AM:
-

sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR #920|https://github.com/apache/calcite/pull/920] based branch-1.17, so I 
modified PR #913 or PR #920, not modified PR I close pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 


was (Author: ambition):
sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR 
#920|[https://github.com/apache/calcite/pull/913|https://github.com/apache/calcite/pull/920]]
 based branch-1.17, so I modified PR #913 or PR #920, not modified PR I close 
pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2663:
---

sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR 
#920|[https://github.com/apache/calcite/pull/913|https://github.com/apache/calcite/pull/920]]
 based branch-1.17, so I modified PR #913 or PR #920, not modified PR I close 
pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 2:06 AM:
-

new [PR #920|https://github.com/apache/calcite/pull/920] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".


was (Author: ambition):
new [PR#920|https://github.com/apache/calcite/pull/920] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 2:06 AM:
-

new [PR#920|https://github.com/apache/calcite/pull/920] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".


was (Author: ambition):
new [PR913|https://github.com/apache/calcite/pull/913] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 2:02 AM:
-

new [PR913|https://github.com/apache/calcite/pull/913] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".


was (Author: ambition):
new  [PR920|https://github.com/apache/calcite/pull/920] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: server
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Comment Edited] (CALCITE-2663) create function and drop function SQL statement

2018-11-14 Thread ambition (JIRA) 


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

ambition edited comment on CALCITE-2663 at 11/15/18 1:45 AM:
-

new  [PR920|https://github.com/apache/calcite/pull/920] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".


was (Author: ambition):
new  [PR913|https://github.com/apache/calcite/pull/913] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (CALCITE-2663) create function and drop function SQL statement

2018-11-13 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2663:
---

new  [PR913|https://github.com/apache/calcite/pull/913] , support "CREATE OR 
REPLACE FUNCTION", and "DROP FUNCTION".

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP TEMPORARY FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (CALCITE-2663) create function and drop function SQL statement

2018-11-13 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Description: 
support create function and drop function statement like apache hive:
{code:java}
CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
class_name
  [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];

DROP FUNCTION [IF EXISTS] function_name; 
{code}
 

 

  was:
support create function and drop function statement like apache hive:
{code:java}
CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
class_name
  [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];

DROP TEMPORARY FUNCTION [IF EXISTS] function_name; 
{code}
 

 


> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (CALCITE-2663) create function and drop function SQL statement

2018-11-13 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Summary: create function and drop function SQL statement  (was: CREATE 
FUNCTION SQL statement)

> create function and drop function SQL statement
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP TEMPORARY FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (CALCITE-2663) CREATE FUNCTION SQL statement

2018-11-13 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Description: 
support create function and drop function statement like apache hive:
{code:java}
CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
class_name
  [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];

DROP TEMPORARY FUNCTION [IF EXISTS] function_name; 
{code}
 

 

  was:
support create function statement like hive:

 

 
{code:java}
CREATE FUNCTION [db_name.]function_name AS class_name
  [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
{code}
 

 


> CREATE FUNCTION SQL statement
> -
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP TEMPORARY FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (CALCITE-2663) CREATE FUNCTION SQL statement

2018-11-12 Thread ambition (JIRA) 


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

ambition commented on CALCITE-2663:
---

  Read view comments, I can support "CREATE FUNCTION" and  "DROP FUNCTION"  
statement. Our online apache flink( uses the calcite SQL engine ) environment 
has stabilized the operation of this SQL syntax. File URI by 
URLClassLoader.loadClass(class_name) operator.  I  can try to  modify code that 
accord to the comment requirements.

  

 

> CREATE FUNCTION SQL statement
> -
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function statement like hive:
>  
>  
> {code:java}
> CREATE FUNCTION [db_name.]function_name AS class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (CALCITE-2663) CREATE FUNCTION SQL STAMENT

2018-11-11 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Fix Version/s: 1.16.0

> CREATE FUNCTION SQL STAMENT
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.16.0, 1.17.0
>
>
> support create function statement like hive:
>  
>  
> {code:java}
> CREATE FUNCTION [db_name.]function_name AS class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (CALCITE-2663) CREATE FUNCTION SQL STAMENT

2018-11-11 Thread ambition (JIRA) 


 [ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ambition updated CALCITE-2663:
--
Affects Version/s: 1.16.0

> CREATE FUNCTION SQL STAMENT
> ---
>
> Key: CALCITE-2663
> URL: https://issues.apache.org/jira/browse/CALCITE-2663
> Project: Calcite
>  Issue Type: Improvement
>  Components: core
>Affects Versions: 1.16.0, 1.17.0
>Reporter: ambition
>Assignee: Julian Hyde
>Priority: Minor
> Fix For: 1.17.0
>
>
> support create function statement like hive:
>  
>  
> {code:java}
> CREATE FUNCTION [db_name.]function_name AS class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (CALCITE-2663) CREATE FUNCTION SQL STAMENT

2018-11-08 Thread ambition (JIRA) 
ambition created CALCITE-2663:
-

 Summary: CREATE FUNCTION SQL STAMENT
 Key: CALCITE-2663
 URL: https://issues.apache.org/jira/browse/CALCITE-2663
 Project: Calcite
  Issue Type: Improvement
  Components: core
Affects Versions: 1.17.0
Reporter: ambition
Assignee: Julian Hyde
 Fix For: 1.17.0


support create function statement like hive:

 

 
{code:java}
CREATE FUNCTION [db_name.]function_name AS class_name
  [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
{code}
 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)