Re: Distinct clause in hive

Hi Rakesh, How big are your files? and is the data ordered/sorted by column on which you are running distinct on? if column contains empty string, null and spaces which all treated as different by hive. Converting them to hive's native null type can help in improving performance.. Thank you,

Distinct clause in hive

When using distinct in hive query it runs for hours otherwise it's running for less than a minute. How can I optimise thisvquery. Thanks Get Outlook for Android