Could not open input file for reading in Hive

Technical Discussions Hive
#1

I have uploaded my Hive database creation script and table creation in single file as DBtabcreation.sql in user path /user/mittalvibhor28719/Trial through Hue and then trying to execute the same in web console through below command.

hive -f /user/mittalvibhor28719/Trial/DBtabcreation.sql

and getting error as

log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
Logging initialized using configuration in file:/etc/hive/2.6.5.0-292/0/hive-log4j.properties
Could not open input file for reading. (File file:/user/mittalvibhor28719/Trial/DBtabcreation.sql does not exist)

image
image1214×119 9.89 KB

please help.

#2

@abhinav please help

#3

Probably the hive requires the file to in local file system therefore it may not work.

I would suggest copying the file to local file system using:
hadoop fs -copyToLocal /user/mittalvibhor28719/Trial/DBtabcreation.sql

And then try running:

hive DBtabcreation.sql