Hi ,
Thanks for the information. But the PARGMA is not working. Its giving parse
exception as seen below. I tried different combination of this statement
but none of it worked.
0: jdbc:ignite:thin://127.0.0.1/> PRAGMA PUBLIC.table_info(SUPPLIER);
Error: Failed to parse query. Syntax error in SQL statement "PRAGMA[*]
PUBLIC.TABLE_INFO(SUPPLIER) "; expected "PREPARE, {"; SQL statement:
PRAGMA PUBLIC.table_info(SUPPLIER) [42001-197] (state=42000,code=1001)
java.sql.SQLException: Failed to parse query. Syntax error in SQL
statement "PRAGMA[*] PUBLIC.TABLE_INFO(SUPPLIER) "; expected "PREPARE,
{"; SQL statement:
PRAGMA PUBLIC.table_info(SUPPLIER) [42001-197]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
at sqlline.Commands.executeSingleQuery(Commands.java:1054)
at sqlline.Commands.execute(Commands.java:1003)
at sqlline.Commands.sql(Commands.java:967)
at sqlline.SqlLine.dispatch(SqlLine.java:734)
at sqlline.SqlLine.begin(SqlLine.java:541)
at sqlline.SqlLine.start(SqlLine.java:267)
at sqlline.SqlLine.main(SqlLine.java:206)
On Thu, Jun 2, 2022 at 3:34 PM Юрий <[email protected]> wrote:
> Hi,
> There is the ticket [1] for the issue.
> While the ticket is not resolved try to use PRAGMA
> table_info(table-name); as explained in the SQLite PRAGMA documentation
> [2].
>
> [1] https://issues.apache.org/jira/browse/IGNITE-16667
> [2] http://www.sqlite.org/pragma.html#pragma_table_info
>
> пн, 30 мая 2022 г. в 14:08, Sachin janani <[email protected]>:
>
>> Hi ,
>> I have created a table in ignite using SQLLine and I want to see which
>> columns in that table are the primary key. When i queried
>> *SYS.TABLE_COLUMNS* I don't see the Primary key columns.Can someone
>> please help me how can i get the primary key columns of already created
>> ignite table? Following is the table i have created and the output of the
>> *SYS.TABLE_COLUMNS*:
>>
>> 0: jdbc:ignite:thin://127.0.0.1/> CREATE TABLE SUPPLIER (
>> . . . . . . . . . . . . . . . .)> S_SUPPKEY INT,
>> . . . . . . . . . . . . . . . .)> S_NAME VARCHAR,
>> . . . . . . . . . . . . . . . .)> S_ADDRESS VARCHAR,
>> . . . . . . . . . . . . . . . .)> S_CITY VARCHAR,
>> . . . . . . . . . . . . . . . .)> S_NATION VARCHAR,
>> . . . . . . . . . . . . . . . .)> S_REGION VARCHAR,
>> . . . . . . . . . . . . . . . .)> S_PHONE VARCHAR, PRIMARY
>> KEY(S_SUPPKEY, S_REGION)) WITH "TEMPLATE=PARTITIONED, AFFINITY_KEY=S_REGION";
>> No rows affected (0.047 seconds)
>> 0: jdbc:ignite:thin://127.0.0.1/> select * from sys.TABle_COLUMNS;
>> +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+-------------------+
>> | COLUMN_NAME | TABLE_NAME | SCHEMA_NAME | AFFINITY_COLUMN | AUTO_INCREMENT
>> | DEFAULT_VALUE | NULLABLE | PK | PRECISION | SCALE | TYPE |
>> +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+-------------------+
>> | _KEY | SUPPLIER | PUBLIC | false | false
>> | | false | true | -1 | -1 | |
>> | _VAL | SUPPLIER | PUBLIC | false | false
>> | | true | false | -1 | -1 | |
>> | S_SUPPKEY | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.Integer |
>> | S_NAME | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> | S_ADDRESS | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> | S_CITY | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> | S_NATION | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> | S_REGION | SUPPLIER | PUBLIC | true | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> | S_PHONE | SUPPLIER | PUBLIC | false | false
>> | null | true | false | -1 | -1 | java.lang.String |
>> +-------------+------------+-------------+-----------------+----------------+---------------+----------+-------+-----------+-------+-------------------+
>> 9 rows selected (0.004 seconds)
>> 0: jdbc:ignite:thin://127.0.0.1/>
>>
>> As seen from the above output i dont see S_SUPPKEY and S_REGION as
>> primary key instead I see _KEY as primary key. So i want to know how can i
>> find which columns in the table are primary key from SQLLine?
>>
>> Thanks and Regards,
>> --
>> *Sachin Janani*
>>
>>
>
>
> --
> Живи с улыбкой! :D
>
--
*Sachin Janani*
