Reply
New Contributor
Posts: 5
Registered: ‎05-30-2017

hive error ,org.apache.commons.logging.impl.SLF4JLogFactory ?

trying to execute hive-sql file through cloudera hive

but recieving some log.4j error ?

 

Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
OK
Time taken: 4.374 seconds
OK
Time taken: 0.219 seconds
OK
Time taken: 0.683 seconds
OK
Time taken: 0.167 seconds
OK
Time taken: 0.13 seconds
OK
Time taken: 0.391 seconds
OK
Time taken: 0.517 seconds
WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.
WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.
[cloudera@quickstart hackerday-spark-hive-solution]$ ls
datasets  hands-on-step-note.txt  hdfs_commands.txt  hive_query.sql  project1  spark-one.scala
[cloudera@quickstart hackerday-spark-hive-solution]$ hive -f hive_query.sql 

Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database movie_dw already exists
WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.
WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.

any help how to resolve this error  ?

Posts: 465
Topics: 1
Kudos: 58
Solutions: 38
Registered: ‎08-16-2016

Re: hive error ,org.apache.commons.logging.impl.SLF4JLogFactory ?

The log4j messages are just noise.

Your error is "Database movie_dw already exists".

Add an "IF EXIST" to the HQL script were you are creating the movie_dw database. This will keep the command in place but have it not fail entirely on an error.
Highlighted
New Contributor
Posts: 5
Registered: ‎05-30-2017

Re: hive error ,org.apache.commons.logging.impl.SLF4JLogFactory ?

ok, thankyou for replying.

 

i just saw the tables are already populated .

 

 

Announcements