Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is it possible to run phoenix sql query using input parameter from cmd?

Is it possible to run phoenix sql query using input parameter from cmd?

Explorer

Hi,

I would like to call and sql file with a query using input parameter. eg: providing where col1 = $param1 and col2 = $param2

it would also work for me if psql could be called with a query flag, (and provide query there) then i could handle it from bash.

Is there a possibility for any solution of the above two?

thanks,

clairvoyant

update: from bash it works already using sqlline.

1 REPLY 1
Highlighted

Re: Is it possible to run phoenix sql query using input parameter from cmd?

Explorer

from bash i can solve with sqlline, but is there a more sophisticated way? what is the best practice for such cases?

Don't have an account?
Coming from Hortonworks? Activate your account here