Thanks a lot Jason for the immediate turn around It worked marvel for us. 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] | www.sidra.org <http://www.sidra.org/> On 10/15/16, 7:12 PM, "Jason Altekruse" <[email protected]> wrote: 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. > 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.
