a1
1 1 1 1 1 CREATE EXTERNAL TABLE IF NOT EXISTS ventes ( date STRING, produit STRING, quantite INT, prix_unitaire INT, region STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ STORED AS TEXTFILE LOCATION ‘/user/cloudera/tp_hive/data’ TBLPROPERTIES (‘skip.header.line.count’=’1’); SELECTregion,SUM(quantite * prix_unitaire) AS ca_totalFROM ventesGROUP BY regionORDER BY ca_total DESC; Location: hdfs://…/user/cloudera/tp_hive/data SELECTregion,SUM(quantite * prix_unitaire) AS […]

