Lateral Views and Multi Table Insert

2012-10-05 Thread Jim Krehl
Hi, I have a question about using lateral views with multi table insert. I have a table of data that represents raw log data, the structure of which makes it onerous to query directly largely because it requires UNIONTYPE columns. So, I transform that raw table into 3 new tables, a primary table

Lateral Views and Multi Table Insert

2012-10-04 Thread Jim Krehl
Hi, I have a question about using lateral views with multi table insert. I have a table of data that represents raw log data, the structure of which makes it onerous to query directly largely because it requires UNIONTYPE columns. So, I transform that raw table into 3 new tables, a primary table