Tableau connection

Available in VPC

Supporting fast and easy data visualization, Tableau is currently one of most commonly used BI solutions.
This guide introduces how to connect NAVER Cloud Platform's Cloud Hadoop and Tableau.

Please refer to the Official Tableau website for more information about Tableau.

Preparations

1. Create Cloud Hadoop cluster.
   • Please refer to Getting started with Cloud Hadoop for more information about creating Cloud Hadoop cluster.
2. Create Object Storage.
   • Please refer to Object Storage overview for more information about creating Object Storage.
3. Create Windows Server.
   • Please refer to Getting started with Server for more information about creating Windows Server.

4. Set ACG up.
   • Add Port 8286 to Cloud Hadoop ACG.
     

Create table in Hive

1. Update a sample data file to Object Storage.

   • Download and decompress the sample data here and upload the AllstarFull.csv file to Object Storage > Bucket Management.
     

2. Create a table in the HUE Hive editor.

DROP table allstarfull;

CREATE external TABLE if not EXISTS `allstarfull` (
        `playerID` VARCHAR(20),
        `yearID` INT,
        `gameNum` INT,
        `gameID` VARCHAR(30),
        `teamID` VARCHAR(4),
        `lgID` VARCHAR(4),
        `GP` INT,
        `startingPos` INT
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
location 's3a://deepdrive-hue/input/lahman2012/allstarfull';

3. Use a simple query to see if the table is successfully created.

SELECT * FROM allstarfull;

Add Presto connector

1. Add a connector to Presto > [CONFIGS] > Advanced connectors.properties.
   • Since you need to add a Hive connector, enter the following on connectors.to.add:

{"hive":["connector.name=hive-hadoop2",
        "hive.metastore.uri=thrift://<METASTORE-HOST-IP>:9083",
        "hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml",
        "hive.s3.use-instance-credentials=false",
        "hive.s3.aws-access-key=<API-ACCESS-KEY>",
        "hive.s3.aws-secret-key=<API-SECRET-KEY>",
        "hive.s3.endpoint=https://kr.object.private.ncloudstorage.com"]
        }

2. Please apply for configuration. Click [ACTIONS] > [Restart All] in the upper right corner, and then click the [CONFIRM RE ALL] button in the pop-up window.

Install Tableau

All the steps below should be performed in Windows Server.

1. Download Tableau Desktop on the Tableau website.
2. Download the Presto JDBC driver (presto-jdbc-0.268.jar) on the Presto website.
3. Move the Presto JDBC driver to the drivers directory where Tableau is installed.
   

Install nginx-ssl.crt certificate

1. Move the /etc/nginx/ssl/nginx-ssl.crt certificate from the Cloud Hadoop edge node to Windows Server.

   • Please refer to the How to connect via SSH to cluster nodes guide for information on how to connect to edge node.
     

2. Double-click the nginx-ssl.crt certificate, and then click the [Install certificate] button.
   

3. Select "Local computer," and then click the [Next] button.
   

4. Select "Save all certificates to the following storage," followed by the certificate storage you want.

   • Set the certificate storage as "reliable root certificate authority."
     

5. Click the [Finish] button to complete installing the certificate.
   

Access Presto on Tableau Desktop

1. Run Tableau Desktop and select Connect to server > View more > Presto.
   

2. Enter the access information and click the [Login] button.

Access information 
 - Server: Domain in Presto cluster
 - Port: Port in Presto coordinator (8286)
 - Catalog: Name of the catalog to use
 - Schema: Name of the schema to use
 - User name: Name of the user
 - SSL required: Check

Check table and record

1. Click Include and search to check table of the schema.
   

2. Click the [Update now] button to load the data in the table.
   

3. You can create a new sheet for easy visualization with drag and drop only.