Jach/testr — Issue #74: [DDB-33] Add "Automatically Create Table" checkbox to LucidDB streaming loader
Author: Jach
Created: 2011-12-30 00:05:57+00:00
State: closed
Labels: Tool Integration - ETL

[created="Sun, 13 Jun 2010 20:02:45 -0700", resolved="Tue, 30 Aug 2011 12:09:41 -0700"]

Add a checkbox to the LucidDB streaming loader "Automatically Create Table"

If INS/UPD/MERGE and the checkbox is applied the streaming loader should

Check to see if the table exists

If the table exists, do nothing

If the table does not exist, use the "CREATE_TABLE_AS_SELECT() with load = false" using all the regular cursor rules to create the table for this streaming load. NOTE: This operation does NOT need to open an HTTP socket (can just use a dummy cursor generation)