Considering a scenario where rowkey is combination of parts delimited by " | ". Row Key : part1|part2|part3|1000 column family:f column: "c1" value: "1" Row Key : part1|part2|part3|1001 column family:f column: "c2" value: "2" How to create view in phoenix that looks like. and insert values into Hbase through phoenix col1 col2 col3 col4 c1 c2 part1 part2 part3 1000 1 null part1 part2 part3 1001 null 2 ... View more