question Re: not able to run hive query by putting it into .sql file in Support Questions

not able to run hive query by putting it into .sql file

tajinderdhanjal — Sun, 29 May 2016 00:53:30 GMT

I am able to run hive query through its shell but not able to run it by putting it into file. It gives me permission denied.

I tried to run it through hdfs user but still getting same error.

jyadav — Sun, 29 May 2016 00:54:31 GMT

Please share the steps you performed along with error message.

KuldeepK — Sun, 29 May 2016 04:20:55 GMT

Below are the valid examples for running hive queries

Example of running a query from the command line

$HIVE_HOME/bin/hive -e 'select a.col from tab1 a'

Example of setting Hive configuration variables

$HIVE_HOME/bin/hive -e 'select a.col from tab1 a' --hiveconf hive.exec.scratchdir=/home/my/hive_scratch  --hiveconf mapred.reduce.tasks=32

Example of dumping data out from a query into a file using silent mode
```
$HIVE_HOME/bin/hive -S -e 'select a.col from tab1 a' > a.txt
```
Example of running a script non-interactively from local disk
```
$HIVE_HOME/bin/hive -f /home/my/hive-script.sql
```

Example of running a script non-interactively from a Hadoop supported filesystem (starting in Hive 0.14)

$HIVE_HOME/bin/hive -f hdfs://<namenode>:<port>/hive-script.sql
$HIVE_HOME/bin/hive -f s3://mys3bucket/s3-script.sql

Example of running an initialization script before entering interactive mode
```
$HIVE_HOME/bin/hive -i /home/my/hive-init.sql
```

tajinderdhanjal — Mon, 30 May 2016 15:55:51 GMT

Thanks kuldeep i am able to run hive queries by putting in file now.