phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Passing arguments (schema name) to .sql file while executing from command line
Date Fri, 21 Apr 2017 06:12:20 GMT
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:

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

Mime
View raw message