It looks like what is in your string literal is not a single quote. If that is what you are looking for, you can include a single quote in a literal by escaping it with itself.
0: jdbc:drill:zk=local> select 'Parkinson''s disease' from sys.version; +----------------------+ | EXPR$0 | +----------------------+ | Parkinson's disease | +----------------------+ If you need a non-ascii character you can give unicode literals with this syntax, notice the U& before and the uescape '\' after the string literal 0: jdbc:drill:zk=local> select U&'Parkinsons\2018s disease' uescape '\' from sys.version; +-----------------------+ | EXPR$0 | +-----------------------+ | Parkinsons‘s disease | +-----------------------+ 1 row selected (0.125 seconds) Here is a list of characters similar to single quote that you can try [1], but you should be able to just copy-paste the character from your source data into some online tool to find the exact character code for it. [1] - https://www.cs.sfu.ca/~ggbaker/reference/characters/#single Jason Altekruse Software Engineer at Dremio Apache Drill Committer On Sat, Oct 15, 2016 at 2:56 AM, Tushar Pathare <[email protected]> wrote: > Hello Team, > Is there a quick fix of workaround for non asci > character parsing.I am specifically looking for an apostrophe search > Like as in > > SELECT * from HISTORY_VALUE_D WHERE HISTORY_VALUE_NAME like 'Parkinson`s > disease' > https://issues.apache.org/jira/browse/DRILL-4039 > > Much needed this fix as it can be a show stopper for us. > > Thanks > > > Tushar B Pathare > High Performance Computing (HPC) Administrator > General Parallel File System > Scientific Computing > Bioinformatics Division > Research > > "what ever the mind of man can conceive and believe, drill can query" > > Sidra Medical and Research Centre > Sidra OPC Building > PO Box 26999 | Doha, Qatar > Near QNCC,5th Floor > Office 4003 3333 ext 37443 | M +974 74793547 > [email protected]<mailto:[email protected]> | www.sidra.org<http://www. > sidra.org/> > > Disclaimer: This email and its attachments may be confidential and are > intended solely for the use of the individual to whom it is addressed. If > you are not the intended recipient, any reading, printing, storage, > disclosure, copying or any other action taken in respect of this e-mail is > prohibited and may be unlawful. If you are not the intended recipient, > please notify the sender immediately by using the reply function and then > permanently delete what you have received. Any views or opinions expressed > are solely those of the author and do not necessarily represent those of > Sidra Medical and Research Center. >
