Support Questions
Find answers, ask questions, and share your expertise

How can i run multiple sql files (init files) in hive?

New Contributor

I have the folliwng query i run in cmd: 

 

"hive -i <(echo 'set hive.cli.print.header=true;') -f '.file_submit/tester.hql' -i .file_submit/temp_settings.hql"

 my temp_settings contains thing like: 

SET start_dt = '201801';SET schema = products; 

 

when i run the above i get an error: 

 

WARN conf.HiveConf: HiveConf of name hive.mapred.strict does not exist
21/06/14 13:48:16 WARN conf.HiveConf: HiveConf of name hive.mapred.supports.subdirectories does not exist
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.



 what am i doing wrong?

1 REPLY 1

Re: How can i run multiple sql files (init files) in hive?

Expert Contributor

You are not doing anything wrong. These are warnings, not necessarily errors. 

 

Please see this discussion for how to get rid of them, if that's what you are aiming for:

https://community.cloudera.com/t5/Support-Questions/Hive-CLI-session-warnings/td-p/242988