Re: set table schema in sqlline command line

[Вячеслав Коптилин <sl...@gmail.com>]

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 <sh...@neulion.com.cn>:

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