You basically need to do a nested-explode here.

SELECT user_id, product_id, prod_and_ts_split FROM (
SELECT  * FROM (select user_id, prod_and_ts.product_id as product_id,
prod_and_ts.timestamps as timestamps FROM testingtable2 LATERAL VIEW
explode(purchased_item) exploded_table as prod_and_ts) prod_and_ts
) tt2 LATERAL VIEW explode(split(timestamps, "#")) exploded_table2 as
prod_and_ts_split;

Thanks,
Vijay

On Wed, Jul 18, 2012 at 2:24 PM, Raihan Jamal <[EMAIL PROTECTED]> wrote:
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB