question Can I write a script to perform a phoenix query and write the output to a file? in Archives of Support Questions (Read Only)

Can I write a script to perform a phoenix query and write the output to a file?

zack_riesland — Tue, 21 Jun 2016 00:20:12 GMT

I know how to accomplish this with Java, but I'm wondering if there is a simpler way using some sort of CLI client and piping.

I just want to run a set query, and write the results to a text file.

And I want to be able to execute this from a shell script.

Any suggestions?

rgelhausen — Tue, 21 Jun 2016 00:33:22 GMT

bash> cat /path/to/my_script.sql

!outputformat csv

select count(*) from system.catalog

/usr/hdp/current/phoenix-client/bin/sqlline.py zk_host:2181:/hbase-unsecure /path/to/my_script.sql > out.txt

bash> cat out.txt

83/83 (100%) Done

'COUNT(1)'

'87'

zack_riesland — Tue, 21 Jun 2016 01:10:35 GMT

Perfect! Thanks!

zack_riesland — Tue, 21 Jun 2016 01:32:46 GMT

In your example, do you know how I would filter everything but the count?

So instead of

83/83 (100%) Done

'COUNT(1)'

'87'

I would only print

rgelhausen — Tue, 21 Jun 2016 01:57:59 GMT

Unfortunately I don't. I suggest an inverted grep on the file like: grep -v '(100%) Done' out.txt

sunilsahub4u — Mon, 16 Oct 2017 15:10:36 GMT

Can we check if below job failed.

/usr/hdp/current/phoenix-client/bin/sqlline.py zk_host:2181:/hbase-unsecure /path/to/my_script.sql > out.txt

Even though it fails I am getting $? as zero. Is there any way to check the same.