You can create a custom function to do that: - https://drill.apache.org/docs/develop-custom-functions/
this will end with something like: select * from *.csv where GET_VALUE(col[x] , 'var1' ) = 'value' (I will publish, in the next few day, a similar function parsing URL in values in this repo : https://github.com/mapr-demos/simple-drill-functions ) t On Wed, Oct 7, 2015 at 4:22 PM, <[email protected]> wrote: > Hi, > > If I have a separated file (PSV/TSV etc) with a number of columns, each > with a single value aside from the last column which contains a bunch of > key value pairs in a string e.g. var1=test var2=test var3=test. Is it > possible to query based on individual key/value items in the last column? I > am looking to querying nested data without using LIKE wildcards in where > statements (I am not sure this is possible with separated text data). > > Does anyone have any advice on whether this is possible? > > Thanks, > Mike > > > This e-mail (including any attachments) is private and confidential, may > contain proprietary or privileged information and is intended for the named > recipient(s) only. Unintended recipients are strictly prohibited from > taking action on the basis of information in this e-mail and must contact > the sender immediately, delete this e-mail (and all attachments) and > destroy any hard copies. Nomura will not accept responsibility or liability > for the accuracy or completeness of, or the presence of any virus or > disabling code in, this e-mail. If verification is sought please request a > hard copy. Any reference to the terms of executed transactions should be > treated as preliminary only and subject to formal written confirmation by > Nomura. Nomura reserves the right to retain, monitor and intercept e-mail > communications through its networks (subject to and in accordance with > applicable laws). No confidentiality or privilege is waived or lost by > Nomura by any mistransmission of this e-mail. Any reference to "Nomura" is > a reference to any entity in the Nomura Holdings, Inc. group. Please read > our Electronic Communications Legal Notice which forms part of this e-mail: > http://www.Nomura.com/email_disclaimer.htm > >
