Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Explorer

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  ?

2 REPLIES 2

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

Champion
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.

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

Explorer

ok, thankyou for replying.

 

i just saw the tables are already populated .