Performing MULTIPLE DISTINCTS on Columns using Hive

["Narla,Venkatesh" <Ve...@Cerner.com>]

Hello,

I  am using Hive to analyze some data. As part of my hive queries I am trying to do Distinct  select on different columns and I am not able to get that well.

I am performing explode on data as its type is array<struct>. I am not able to


Select DISTINCT (lateral_test.id, lateral_test.person.datetime) from hive_test LATERAL VIEW EXPLODE(key.data) explodedtable as lateral_test  where key.id=1 and key.prson=test
And lateral_test.person.datetime=12345669


Exception:

FAILED: ParseException line 1:37 missing ) at ',' near '<EOF>'
line 1:84 extraneous input ')' expecting FROM near '<EOF>'


I have also tried this way by modifying my query.


Select DISTINCT (lateral_test.id), DISTINCT(lateral_test.person.datetime) from hive_test LATERAL VIEW EXPLODE(key.data) explodedtable as lateral_test  where key.id=1 and key.prson=test
And lateral_test.person.datetime=12345669




Exception:


FAILED: ParseException line 1:40 cannot recognize input near 'DISTINCT' '(' 'result_data' in select expression

I would appreciate if any body could guide me where I am doing wrong or how I should be able to proceed with that. Thank you for your time.


Regards,
VN

CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024.