Accessing Generated Tables in Hive

If not already completed, the schema generation process described in "Schema Generation" should have been followed. This creates the necessary Hive schema and staging schema definitions.

Once the tables have been created through ddlscan you can query the stage tables:

hive> select * from stage_xxx_movies_large limit 10;
OK
I 10  1 57475 All in the Family 1971  Archie Feels Left Out (#4.17)
I 10  2 57476 All in the Family 1971  Archie Finds a Friend (#6.18)
I 10  3 57477 All in the Family 1971  Archie Gets the Business: Part 1 (#8.1)
I 10  4 57478 All in the Family 1971  Archie Gets the Business: Part 2 (#8.2)
I 10  5 57479 All in the Family 1971  Archie Gives Blood (#1.4)
I 10  6 57480 All in the Family 1971  Archie Goes Too Far (#3.17)
I 10  7 57481 All in the Family 1971  Archie in the Cellar (#4.10)
I 10  8 57482 All in the Family 1971  Archie in the Hospital (#3.15)
I 10  9 57483 All in the Family 1971  Archie in the Lock-Up (#2.3)
I 10  10  57484 All in the Family 1971  Archie Is Branded (#3.20)