RE: Drill Question

2021-04-22 Thread jinseong.gim
Dear Supporter, I'm very appreciate to your prompt and concise feedback. I found that below code does work! Many thanks and Have a Nice Day, Jinseong -Original Message- From: Charles Givre Sent: Thursday, April 22, 2021 8:52 PM To: Gim,Jinseong (MED BDS) NBI-JP-T Cc: user Subject:

Re: May I ask a question about SQL syntax?

2021-04-22 Thread James Turton
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

Drill Question

2021-04-22 Thread Charles Givre
Hi Jinseong, I saw your question on the Drill list. I think the issue you're having is relating to the quotes. Single quotes should be used to escape string values. Back ticks should be used for the actual variable name. IE: ALTER SYSTEM SET `system.some_variable` = 'value'; Please let us

May I ask a question about SQL syntax?

2021-04-22 Thread jinseong.gim
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]