Hive Explode / Lateral View multiple arrays

by

I found a very good solution to this problem without using any UDF,
posexplode is a very good solution :

SELECT COOKIE ,
ePRODUCT_ID,
eCAT_ID,
eQTY
FROM TABLE 
LATERAL VIEW posexplode(PRODUCT_ID) ePRODUCT_IDAS seqp, ePRODUCT_ID
LATERAL VIEW posexplode(CAT_ID) eCAT_ID AS seqc, eCAT_ID
LATERAL VIEW posexplode(QTY) eQTY AS seqq, eDateReported
WHERE seqp = seqc AND seqc = seqq;

More Related Contents:

  1. How to set variables in HIVE scripts
  2. Specify minimum number of generated files from Hive insert
  3. java.lang.RuntimeException:Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  4. Hive: Best way to do incremetal updates on a main table
  5. HIVE select count(*) non null returns higher value than select count(*)
  6. Execute Hive Query with IN clause parameters in parallel
  7. HiveQL: Using query results as variables
  8. Difference between Hive internal tables and external tables?
  9. How do I output the results of a HiveQL query to CSV?
  10. How to create n number of external tables with a single hdfs path using Hive
  11. Create Table in Hive with one file
  12. Find last day of a month in Hive
  13. How to update table in Hive 0.13?
  14. When creating an external table in hive can I point the location to specific files in a directory?
  15. How to skip CSV header in Hive External Table?
  16. How to update partition metadata in Hive , when partition data is manualy deleted from HDFS
  17. How can I convert array to string in hive sql?
  18. Update , SET option in Hive
  19. What is the equivalent of Presto UNNEST function in Hive
  20. Split a comma-delimited string into an array?
  21. PHP explode the string, but treat words in quotes as a single word
  22. Convert a comma-delimited string into array of integers?
  23. How to export a Hive table into a CSV file?
  24. PHP: How can I explode a string by commas, but not wheres the commas are within quotes?
  25. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  26. Hive – Unpivot functionality in hive
  27. Hive: Add partitions for existing folder structure
  28. Explode a paragraph into sentences in PHP
  29. Job queue for Hive action in oozie
  30. Split a string with two delimiters into two arrays (explode twice)

Leave a Comment