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 <[email protected]> Sent: Thursday, April 22, 2021 8:52 PM To: Gim,Jinseong (MED BDS) NBI-JP-T <[email protected]> Cc: user <[email protected]> Subject: Drill Question CAUTION! Please do not click links or open attachments unless you recognize the sender, this email is from an External Sender (outside Boehringer-Ingelheim) 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 know if that works. Here's the docs for that as well (https://drill.apache.org/docs/alter-system/) Best, -- C
