Reply
Highlighted
Explorer
Posts: 6
Registered: ‎08-19-2016

Hue Hive editor not giving result when using Email ID field in where clause

[ Edited ]

Hi,

 

Im using the below query, which is running fine in Beeline but not giving results in Hue Hive editor.

 

select * from tmp_stage.contact_final_test where email = 'Sample1234@yahoo.com'; // Its coming as loading. It

 

Also, the below query  giving the result but not able to export the result to CSV or Excel in Hue Hive editor. I have tried by filtering with other fields whcih is exporitng the result but when using the below query, its getting timed out error.

 

select * from luck_contact where verity_contact.email_domain = 'xxx.com';

 

And, it is unable to use the basic CTAS queries in Hue Hive editor.

 

I have attached the error message for reference.

 

Early fix would be much appreciable.

 

Note:

 

Im using HDP 2.5 and Hue 3.12

 

Thanks,

MJ

Announcements