[jira] [Commented] (LIVY-637) get NullPointerException when create database using thriftserver
[ https://issues.apache.org/jira/browse/LIVY-637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913001#comment-16913001 ] Saisai Shao commented on LIVY-637: -- Issue resolved by pull request 200 https://github.com/apache/incubator-livy/pull/200 > get NullPointerException when create database using thriftserver > > > Key: LIVY-637 > URL: https://issues.apache.org/jira/browse/LIVY-637 > Project: Livy > Issue Type: Bug > Components: Thriftserver >Affects Versions: 0.6.0 >Reporter: mingchao zhao >Assignee: mingchao zhao >Priority: Major > Fix For: 0.7.0 > > Attachments: create.png, drop.png, use.png > > Time Spent: 4h > Remaining Estimate: 0h > > When I connected thriftserver with spark beeline. NullPointerException occurs > when execute the following SQL. This exception does not affect the final > execution result. > create database test; > use test; > drop database test; > 0: jdbc:hive2://localhost:10090> create database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> use test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> drop database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > -- This message was sent by Atlassian Jira (v8.3.2#803003)
[jira] [Commented] (LIVY-637) get NullPointerException when create database using thriftserver
[ https://issues.apache.org/jira/browse/LIVY-637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907012#comment-16907012 ] Yiheng Wang commented on LIVY-637: -- Spark beeline uses an older hive-jdbc-client version, in which it will not check if the column is null in the RowSet returned by the thrift server. See here: [https://github.com/apache/hive/blob/release-1.2.1/service/src/java/org/apache/hive/service/cli/ColumnBasedSet.java#L50] In the latest hive code, this has been fixed [https://github.com/apache/hive/blob/master/service/src/java/org/apache/hive/service/cli/ColumnBasedSet.java#L82] > get NullPointerException when create database using thriftserver > > > Key: LIVY-637 > URL: https://issues.apache.org/jira/browse/LIVY-637 > Project: Livy > Issue Type: Bug > Components: Thriftserver >Affects Versions: 0.6.0 >Reporter: mingchao zhao >Priority: Major > Attachments: create.png, drop.png, use.png > > > When I connected thriftserver with spark beeline. NullPointerException occurs > when execute the following SQL. This exception does not affect the final > execution result. > create database test; > use test; > drop database test; > 0: jdbc:hive2://localhost:10090> create database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> use test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> drop database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Commented] (LIVY-637) get NullPointerException when create database using thriftserver
[ https://issues.apache.org/jira/browse/LIVY-637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906850#comment-16906850 ] mingchao zhao commented on LIVY-637: Same exception when CREATE and DROP TEMPORARY FUNCTION > get NullPointerException when create database using thriftserver > > > Key: LIVY-637 > URL: https://issues.apache.org/jira/browse/LIVY-637 > Project: Livy > Issue Type: Bug > Components: Thriftserver >Affects Versions: 0.6.0 >Reporter: mingchao zhao >Priority: Major > Attachments: create.png, drop.png, use.png > > > NullPointerException occurs when I use thriftserver to execute the following > SQL. This exception does not affect the final execution result. > create database test; > use test; > drop database test; > 0: jdbc:hive2://localhost:10090> create database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> use test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> drop database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Commented] (LIVY-637) get NullPointerException when create database using thriftserver
[ https://issues.apache.org/jira/browse/LIVY-637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906199#comment-16906199 ] mingchao zhao commented on LIVY-637: This exception does not affect the final result. I would like to fix this issues. > get NullPointerException when create database using thriftserver > > > Key: LIVY-637 > URL: https://issues.apache.org/jira/browse/LIVY-637 > Project: Livy > Issue Type: Bug > Components: Thriftserver >Affects Versions: 0.6.0 >Reporter: mingchao zhao >Priority: Major > Attachments: create.png, drop.png, use.png > > > NullPointerException occurs when I use thriftserver to execute the following > SQL. This exception does not affect the final execution result. > create database test; > use test; > drop database test; > 0: jdbc:hive2://localhost:10090> create database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> use test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > 0: jdbc:hive2://localhost:10090> drop database test; > java.lang.NullPointerException > at org.apache.hive.service.cli.ColumnBasedSet.(ColumnBasedSet.java:50) > at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:37) > at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:368) > at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42) > at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1794) > at org.apache.hive.beeline.Commands.execute(Commands.java:860) > at org.apache.hive.beeline.Commands.sql(Commands.java:713) > at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973) > at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813) > at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771) > at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484) > at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467) > Error: Error retrieving next row (state=,code=0) > -- This message was sent by Atlassian JIRA (v7.6.14#76016)
