Re: set table schema in sqlline command line

[Вячеслав Коптилин]

Hello,

It looks like you need to use quote symbols in order to mark that the table
schema is case-sensitive.
Please try the following statement:
select * from "Content".SINTRIPLE;

Thank!

2018-02-22 12:56 GMT+03:00 shawn.du :

> Hi,
>
> I am trying sqlline in CLI,
>
> ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/
>
> I can connect ignite successfully, also
> command !tables can list all tables.
>
> but when I query something, it always fail.
> ++--
> --++
> ++--
> --++
> |   TABLE_CAT|  TABLE_SCHEM   |
> TABLE_NAME   |   TABLE_TYPE   |
>  REMARKS |TYPE_CAT||
> ++--
> --++
> ++--
> --++
> | | Content|
> SINTRIPLE  | TABLE  |
>  |||
> || Content|
> SINTRIPLE  | TABLE  |
>  |||
>
> above are some part of !tables output.
> I want to query sql  from Content schema and Table SINTRIPLE.
> It seems that "select * from Content.SINTRIPLE" doesn't work.
>
> I also tried to set schema in url.
> ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/
> Content
> also doesn't work.
>
> any advice? Thanks in advance.
>
> Thanks
> Shawn
>
>

set table schema in sqlline command line

[shawn.du]

Hi,I am trying sqlline in CLI,./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/I can connect ignite successfully, also command !tables can list all tables.but when I query something, it always fail. 
++++++++|           TABLE_CAT            |          TABLE_SCHEM           |           TABLE_NAME           |           TABLE_TYPE           |            REMARKS             |            TYPE_CAT            |        |++++++++|                                 | Content                        | SINTRIPLE                      | TABLE                          |                                |                                |        ||                                | Content                        | SINTRIPLE                      | TABLE                          |                                |                                |        |
above are some part of !tables output. I want to query sql  from Content schema and Table SINTRIPLE.It seems that "select * from Content.SINTRIPLE" doesn't work.I also tried to set schema in url. ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/Contentalso doesn't work. any advice? Thanks in advance.






ThanksShawn