Passing arguments (schema name) to .sql file while executing from command line

[sid red <si...@gmail.com>]

Hi,

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.

Re: Passing arguments (schema name) to .sql file while executing from command line

[Ankit Singhal <an...@gmail.com>]

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 <si...@gmail.com> wrote:

> Hi,
>
> 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.
>