Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Running sql script using phoenix

Rising Star

I want to drop few phoenix table in using a

Can I write a drop_table.hql and exeucte in phoenix shell ?


Cloudera Employee

You should be able to drop table using phoenix sqlline. /location/of/file/drop_table.sql

Super Collaborator

As @ssattiraju mentioned you may use a file with commands providing it as a command line parameter. One quick note - if one of the commands fail, the script will stop executing. To avoid it you may use just simple redirect like:

phoenix-sqlline localhost < file.sql
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.