Information and discussion related to the Kognitio on Hadoop product
Posts: 185
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Getting started with Hadoop using Kognitio Console (part 2)

by MikeAtkinson » Tue Jun 14, 2016 3:26 pm

In Part 1 we saw how to create a HDFS_CON connector to create a bridge between the Kognitio Analytical Platform and the Hadoop system it is running on. In this post we look at how to use Console to browse Hadoop data and create an external table from that data.

Using the External Data Source.

Open the External Data Sources item in the metadata tree (this might take a while) and data sources available to the user will be shown, in this case hdfs_data which we created in part 1.

Double-click on the External Data Source and the data browser will be opened. This allows navigation of the hadoop tree and examination of files


On navigation down to /user/presales there is a small file test.csv, bringing up the pop-up menu on this.


Clicking on "view file" shows the contents of the file in the right hand pane.


Create external table

Clicking on "Create external table" brings up the "Create External Table" dialog, it may take some time to read a sample of the data and then it profiles that sample to suggest column definitions.


Clicking the "More Options" button brings up tabs which allow the sampling, data format and connector parameters (which are used to access the data) to be changed.


You can also change the table name (which is guessed at from the file name), schema, and column definitions.


On selecting "OK" the external table is created.

Using the external table

The external table can then the accessed like any other table using SQL.


A view of the table may be created and by right clicking on the view and selecting "Create view image" a dialog is shown which allows view images of various types to be shown.


This view can then be accessed much faster than the underlying table.

Reply with quote Top

Who is online

Users browsing this forum: No registered users and 3 guests