If you are using phoenix 4.8 onwards then you can try giving zookeeper string appended with a schema like below.

psql.py <zookeeper>;schema=<schema_name> <path>/create_table.sql 

psql.py zookeeer1;schema=TEST_SCHEMA <path>/create_table.sql

On Sat, Apr 15, 2017 at 2:25 AM, sid red <siddharthreddych@gmail.com> wrote:

I am trying to find a solution, where I can pass arguments, such as schema
name to the .sql file while executing the file from the command line.

Something like this...

psql.py <zookeeper> <path>/create_table.sql TEST_SCHEMA

I have a create table DDL in the script. So, I want to create a table in the
TEST_SCHEMA schema. But want to pass it as an argument.

Your help is much appreciated.

View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Passing-arguments-schema-name-to-sql-file-while-executing-from-command-line-tp3404.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.