What is the current HDP, CDH, or CDP version of this cluster? Is this issue present on every browser? Did it work as expected before?   ... View more

Thanks for your quick reply @smruti , really appreciated.   I have gone through this approach and will surely consider it for DR strategy. ... View more

Hi @HanzalaShaikh,   I'm not having problem with only CAST, as you can see from the second query I wrote, second and third query from my original post works fine. Only combination of CAST and WITH is giving me this error. I'm new with Impala and I haven't use Beeline before (I'll google it though, tnx). ... View more

Hi @ryu , I have recently copied the hive tables from our Production cluster to non production cluster using distcp the location of hive warehouse directory from Prod to non prod, After running distcp we created the table schema  on non prod as same as Prod using 'create table'. If table consist partition then please apply 'alter table' to add partition.   We are also using hive replication to copy the tables from our Prod to DR cluster.   If this has helped you then please mark the answer as solution. ... View more

I think you should check yarn logs for more details info. ... View more

You need to run compute stats on the base tables referenced by the views - compute stats directly on a view isn't supported. ... View more

Thanks a lot @tusharkathpal  for your detailed explanation. Your suggestion has really worked. ... View more