Hello folks, Please help me with the following query: There are two tables T1 and T2 find the sum of price if customer buys all the product how much he has to pay after discount. Table : T1 ================================ ProductID | ProductName | Price -------------------------------- 1 | p1 | 1000 2 | p2 | 2000 3 | p3 | 3000 4 | p4 | 4000 5 | p5 | 5000 Table : T2 ======================= ProductID | Disocunt % ----------------------- 1 | 10 2 | 15 3 | 10 4 | 15 5 | 20 , Hello everyone, Please help me with the following query in Hive. There are two tables T1 and T2 find the sum of price if customer buys all the product how much he has to pay after discount. Table : T1 ================================ ProductID | ProductName | Price -------------------------------- 1 | p1 | 1000 2 | p2 | 2000 3 | p3 | 3000 4 | p4 | 4000 5 | p5 | 5000 Table : T2 ======================= ProductID | Disocunt % ----------------------- 1 | 10 2 | 15 3 | 10 4 | 15 5 | 20 ... View more

Also, this instance is not present in all Regions. Change the Region and give a try. ... View more

You cannot cd into HDFS folders, Try creating a NFS Gateway for your HDFS and you can cd into those directory! After creating a NFS Gateway, run this command : mount -t nfs -o vers=3,proto=tcp,nolock <ip addr>:/ /data/hadoop/hdfs/ ... View more

@Predrag Minovic could you please let me know how did you created hive avro table from hive text table? did you select from text table and created avro table using CREATE AS SELECT? ... View more