You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vihang Karajgaonkar (JIRA)" <ji...@apache.org> on 2016/07/18 19:20:20 UTC
[jira] [Resolved] (HIVE-9478) Beeline CLI Creating and Selecting On
Tables Without Passing in -n Parameter
[ https://issues.apache.org/jira/browse/HIVE-9478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vihang Karajgaonkar resolved HIVE-9478.
---------------------------------------
Resolution: Cannot Reproduce
Assignee: Vihang Karajgaonkar
> Beeline CLI Creating and Selecting On Tables Without Passing in -n Parameter
> ----------------------------------------------------------------------------
>
> Key: HIVE-9478
> URL: https://issues.apache.org/jira/browse/HIVE-9478
> Project: Hive
> Issue Type: Bug
> Components: Beeline
> Affects Versions: 0.13.1
> Reporter: Mac Noland
> Assignee: Vihang Karajgaonkar
> Priority: Minor
>
> When I first got started with beeline, since I was already the cloud user on my edge node (not using Kerbose), I was logging into beeline without passing in a user via –n. Not sure if that was right or not, but seemed to let me create tables. However, when doing this and trying to do a select, I would get the error below. See Appendix #1 for me creating a table and then doing a select to get the error.
> I spent some time messing around with different things and stumbled upon where if a passed in the –n parameter, the select command was completed successfully. See Appendix #2 for that output.
>
> I’m not sure why I could create tables but not select on them when not passing in –n? But then select on the table when passing in my username via –n? I’m not using Kerberos authentication so my expert contact might have suggested that setup might give me a unusual experience.
> Anyway, I’m off and running using the –n parameter but wanted to share my experience as I cut over to beeline. Thanks again in advance for everyone's help and great work on Hive and Beeline.
> Appendix 1
> cloud@c-10-206-76-8:~> beeline -u jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default --verbose=true
> issuing: !connect jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default '' ''
> scan complete in 4ms
> Connecting to jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default
> Connected to: Apache Hive (version 0.13.1-cdh5.2.0)
> Driver: Hive JDBC (version 0.13.1-cdh5.2.0)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 0.13.1-cdh5.2.0 by Apache Hive
> 0: jdbc:hive2://c-10-206-76-8.int.cis.trcloud> create table test123 (test123 int);
> No rows affected (0.217 seconds)
> 0: jdbc:hive2://c-10-206-76-8.int.cis.trcloud> select avg(test123) from test123;
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=1)
> java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:277)
> at org.apache.hive.beeline.Commands.execute(Commands.java:736)
> at org.apache.hive.beeline.Commands.sql(Commands.java:657)
> at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:908)
> at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:770)
> at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:732)
> at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:467)
> at org.apache.hive.beeline.BeeLine.main(BeeLine.java:450)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
> 0: jdbc:hive2://c-10-206-76-8.int.cis.trcloud> !quit
> Appendix #2
> Closing: 0: jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default
> cloud@c-10-206-76-8:~> beeline -u jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default --verbose=true -n cloud
> issuing: !connect jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default cloud ''
> scan complete in 3ms
> Connecting to jdbc:hive2://c-10-206-76-8.int.cis.trcloud:10000/default
> Connected to: Apache Hive (version 0.13.1-cdh5.2.0)
> Driver: Hive JDBC (version 0.13.1-cdh5.2.0)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 0.13.1-cdh5.2.0 by Apache Hive
> 0: jdbc:hive2://c-10-206-76-8.int.cis.trcloud> select avg(test123) from test123;
> +-------+--+
> | _c0 |
> +-------+--+
> | NULL |
> +-------+--+
> 1 row selected (34.084 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)