Forum

Discussions specific to version 8.1
Contributor
Offline
Posts: 185
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Creating external tables via a Kognitio Console dialog

by MikeAtkinson » Thu May 30, 2013 2:57 pm

I've added a feature to Kognitio Console to create external tables from Hadoop or a Kognitio Analytics Platform accessed via a connector.

So for Hadoop, the popup menu for data shows a "Create external table" option.

Image




Selecting that menu option brings up a dialog to create the external table. By default for Hadoop it just contains one varchar column. For external Kognitio Analytics Platform databases it knows the column definitions of the table (or view) and so can fill those in.

Image



Next we may add a separator character to break the rows into fields. The dialog uses code similar to WxLoader to profile each column and create sensible column definitions. The profiler only works on a sample of the data, this means that some columns might have data which exceeds the guesses from the profiler. That is OK as the column definitions may now be altered.

Image



The column definitions may be edited.

For the Hadoop connector, columns at the end may be deselected, which means that they will not appear in the resulting external table, this needs "Ignore extra fields" set so that the extra data in each row in the hadoop data is skipped.

For the Kognitio Analytics Platform connector any of the columns may be deselected, they will not then appear in the resulting external table.

Clicking on "OK" creates the external table.

Image



And here the external table is loaded through the Kognitio Console object viewer.

Image
Reply with quote Top
Contributor
Offline
User avatar
Posts: 48
Joined: Tue May 28, 2013 1:44 pm

Re: Creating external tables via a Kognitio Console dialog

by anonymous2 » Fri Jun 14, 2013 12:52 pm

Thanks Mike, very helpful.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron