You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2016/06/17 17:19:05 UTC
[jira] [Commented] (HIVE-13611) add jar causes beeline not to
output log messages
[ https://issues.apache.org/jira/browse/HIVE-13611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15336495#comment-15336495 ]
Naveen Gangam commented on HIVE-13611:
--------------------------------------
This no longer appears to be an issue. The output is consistent before and after the "add jar" command.
{code}
$ ./bin/beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/Users/ngangam/FOURTH/apache/hive/packaging/target/apache-hive-2.2.0-SNAPSHOT-bin/apache-hive-2.2.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hadoop-dist/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Beeline version 2.2.0-SNAPSHOT by Apache Hive
beeline> !connect "jdbc:hive2://localhost:10000" hive hive
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.2.0-SNAPSHOT)
Driver: Hive JDBC (version 2.2.0-SNAPSHOT)
16/06/17 13:05:04 [main]: WARN jdbc.HiveConnection: Request to set autoCommit to false; Hive does not support autoCommit=false.
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> !tables
+------------+--------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+--+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+------------+--------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+--+
+------------+--------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+--+
0: jdbc:hive2://localhost:10000> create table foo (a string, b int);
No rows affected (1.533 seconds)
0: jdbc:hive2://localhost:10000> select count(*) from foo limit 1;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. tez, spark) or using Hive 1.X releases.
+-----+--+
| c0 |
+-----+--+
| 0 |
+-----+--+
1 row selected (3.186 seconds)
0: jdbc:hive2://localhost:10000> add jar /Users/ngangam/super-csv-2.2.0.jar;
No rows affected (0.013 seconds)
0: jdbc:hive2://localhost:10000> select count(*) from foo limit 1;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. tez, spark) or using Hive 1.X releases.
+-----+--+
| c0 |
+-----+--+
| 0 |
+-----+--+
1 row selected (2.031 seconds)
0: jdbc:hive2://localhost:10000>
{code}
Closing the jira. Please re-open if this issue is reproducible in the latest code base. Thanks
> add jar causes beeline not to output log messages
> -------------------------------------------------
>
> Key: HIVE-13611
> URL: https://issues.apache.org/jira/browse/HIVE-13611
> Project: Hive
> Issue Type: Bug
> Components: Beeline
> Affects Versions: 1.1.0
> Reporter: Thomas Scott
> Assignee: Naveen Gangam
> Priority: Minor
>
> After adding a jar in beeline warning messages and job log ouptut are no longer shown. This only occurs if you use short connection strings (e.g. jdbc:hive2://). Example below:
> {code}
> 0: jdbc:hive2://nightly55-1.gce.cloudera.com:> !connect jdbc:hive2://
> Connecting to jdbc:hive2://
> Enter username for jdbc:hive2://: hive
> Enter password for jdbc:hive2://: ****
> Connected to: Apache Hive (version 1.1.0-cdh5.5.4)
> Driver: Hive JDBC (version 1.1.0-cdh5.5.4)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 1: jdbc:hive2://> select count(*) from sample_07 limit 1;
> INFO : Number of reduce tasks determined at compile time: 1
> INFO : In order to change the average load for a reducer (in bytes):
> INFO : set hive.exec.reducers.bytes.per.reducer=<number>
> INFO : In order to limit the maximum number of reducers:
> INFO : set hive.exec.reducers.max=<number>
> INFO : In order to set a constant number of reducers:
> INFO : set mapreduce.job.reduces=<number>
> INFO : number of splits:1
> INFO : Submitting tokens for job: job_1461621650734_0020
> INFO : The url to track the job: http://nightly55-1.gce.cloudera.com:8088/proxy/application_1461621650734_0020/
> INFO : Starting Job = job_1461621650734_0020, Tracking URL = http://nightly55-1.gce.cloudera.com:8088/proxy/application_1461621650734_0020/
> INFO : Kill Command = /usr/lib/hadoop/bin/hadoop job -kill job_1461621650734_0020
> INFO : Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
> INFO : 2016-04-26 01:36:04,297 Stage-1 map = 0%, reduce = 0%
> INFO : 2016-04-26 01:36:11,802 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 1.52 sec
> INFO : 2016-04-26 01:36:19,419 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 3.25 sec
> INFO : MapReduce Total cumulative CPU time: 3 seconds 250 msec
> INFO : Ended Job = job_1461621650734_0020
> +------+--+
> | _c0 |
> +------+--+
> | 823 |
> +------+--+
> 1 row selected (25.908 seconds)
> 1: jdbc:hive2://> add jar hdfs://some_nn.com/tmp/somedir/some_jar.jar
> 1: jdbc:hive2://> ;
> converting to local hdfs://some_nn.com/tmp/somedir/some_jar.jar
> Added [/tmp/93ca63a2-5019-4f37-b9b4-75f1740b53c8_resources/some_jar.jar] to class path
> Added resources: [hdfs://some_nn.com/tmp/somedir/some_jar.jar]
> No rows affected (0.179 seconds)
> 1: jdbc:hive2://> select count(*) from sample_07 limit 1;
> +------+--+
> | _c0 |
> +------+--+
> | 823 |
> +------+--+
> 1: jdbc:hive2://>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)