Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How can i run multiple sql files (init files) in hive?
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
New Contributor
Created ‎06-14-2021 07:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Master Collaborator
Created ‎06-14-2021 09:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
