[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197285#comment-15197285 ] Herman van Hovell commented on SPARK-13934: --- We overhauled much of the parser infrastructure (including parsing TableIdentifiers). Could you try this on master first? > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197241#comment-15197241 ] Sean Owen commented on SPARK-13934: --- What does scientific notation have to do with it? it's a table identifier. Is it the fact that it starts with a number? > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197244#comment-15197244 ] Yang Wang commented on SPARK-13934: --- A table identifier starting with a number will work here but the one starting in the form of scientific notation like “1e34” will cause this problem. In fact, when SqlParser.parseTableIdentifier parses an identifier like "1e34abcd", the first token it will come across is "1e34" and it will see it as a number, not an valid identifier. > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197266#comment-15197266 ] Apache Spark commented on SPARK-13934: -- User 'wangyang1992' has created a pull request for this issue: https://github.com/apache/spark/pull/11762 > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197558#comment-15197558 ] Herman van Hovell commented on SPARK-13934: --- Could you check if backticked identifiers have this problem? That might be another way out of this. > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197570#comment-15197570 ] Yang Wang commented on SPARK-13934: --- I have checked, backticked identifiers don't have this problem. However, I still think it should be fixed. > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197546#comment-15197546 ] Yang Wang commented on SPARK-13934: --- The master branch don't have this problem. So should create another pr on branch 1.6?[~hvanhovell] > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13934) SqlParser.parseTableIdentifier cannot recognize table name start with scientific notation
[ https://issues.apache.org/jira/browse/SPARK-13934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15209796#comment-15209796 ] Apache Spark commented on SPARK-13934: -- User 'wangyang1992' has created a pull request for this issue: https://github.com/apache/spark/pull/11929 > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation > - > > Key: SPARK-13934 > URL: https://issues.apache.org/jira/browse/SPARK-13934 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.1 >Reporter: Yang Wang > > SqlParser.parseTableIdentifier cannot recognize table name start with > scientific notation like "1e30abcdedfg". > This bug can be reproduced by code following: > val conf = new SparkConf().setAppName(s"test").setMaster("local[2]") > val sc = new SparkContext(conf) > val hc = new HiveContext(sc) > val tableName = "1e34abcd" > hc.sql("select 123").registerTempTable(tableName) > hc.dropTempTable(tableName) > The last line will throw a RuntimeException.(java.lang.RuntimeException: > [1.1] failure: identifier expected) -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org