You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by ji...@boehringer-ingelheim.com on 2021/04/22 07:24:52 UTC

May I ask a question about SQL syntax?

Dear User Supporter.

I have a question about ALTER SESSION statement error as below.
ALTER SESSION SET 'store.format' = 'csv' was not worked, so I amended code as
ALTER SESSION "SET" 'store.format' = 'csv' but there are still error.

Can I resolve this issue?

[cid:image001.png@01D73793.04982900]

[cid:image002.png@01D73794.032F54C0]

Many thanks in advance,

Jinseong

Re: May I ask a question about SQL syntax?

Posted by James Turton <ja...@somecomputer.xyz.INVALID>.

Hi

Images don't aren't delivered to this mailing list but the important 
part is that you've provided enough code as text.  Use backticks to 
enclose identifiers in Drill SQL and single quotes to enclose string 
literals.  Therefore:

ALTER SESSION SET ‘store.format’ = 'csv';

Regards
James


On 2021/04/22 09:24, jinseong.gim@boehringer-ingelheim.com wrote:
>
> Dear User Supporter.
>
> I have a question about ALTER SESSION statement error as below.
>
> ALTER SESSION SET ‘store.format’ = ‘csv’ was not worked, so I amended 
> code as
>
> ALTER SESSION “SET” ‘store.format’ = ‘csv’ but there are still error.
>
> Can I resolve this issue?
>