Tableau integration

Available in VPC

Tableau is a widely used representative BI solution that allows you to visualize data quickly and easily.
This guide shows how to integrate Tableau with NAVER Cloud Platform's Cloud Hadoop.

For more information on Tableau, visit the official Tableau website.

Preliminary task

1. Create a Cloud Hadoop cluster.
   • For more information about how to create a Cloud Hadoop cluster, see Getting started.
2. Create Object Storage.
   • For more information about creating Object Storage, see the Object Storage overview guide.
3. Create a Windows server.
   • For more information about creating a Windows server, see Getting started guide.
4. Set up an ACG.
   • Enter the Windows server IP in the Cloud Hadoop ACG access source and add port 8286 to the allowed ports.
     

Create a table in Hive

1. Upload a sample data file to Object Storage.

   • Download the Sample data file and unzip it.
   • Navigate to Object Storage > Bucket Management, and then upload the AllstarFull.csv file.
     

2. Create a table in the 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 verify that the table was created correctly.

SELECT * FROM allstarfull;

Add the Presto connector

1. Navigate to the Presto > [CONFIGS] tab menu, and then add the connector in Advanced trino.connectors.properties.
   • We need to add the Hive connector, so in the connectors.to.add, enter the following:

{"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. A restart is required to apply the new configuration. Click [ACTIONS] > Restart All in the upper right corner, and then click [CONFIRM RESTART ALL] in the popup window.

Install Tableau

The following Tableau installation process is carried out on a Windows server:

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

Install the nginx-ssl.crt certificate

1. Import the /etc/nginx/ssl/nginx-ssl.crt certificate from the Cloud Hadoop Edge node to your Windows server.

   • For instructions on how to access the edge node, see Access a cluster node with SSH.
     

2. Click on the nginx-ssl.crt certificate and click [Install certificate].
   

3. Select Local Computer and click [Next].
   

4. Select Save all certificates to the following store and select a certificate store:

   • Set the certificate store to Trusted Root Certification Authorities.
     

5. Click [Finish] to complete certificate installation.
   

Access Presto from Tableau Desktop

1. Run Tableau Desktop, then navigate to Connect to server > Details > Presto.
   

2. Enter your access information and click [Log in].

   • Cloud Hadoop version 2.0 or higher

   Access information 
    - Server: Domain of the Presto cluster.
    - Port: Port of the Presto coordinator (8285).
    - Catalog: Name of the catalog to use.
    - Schema: Name of the schema to use.
    - Username: Username to use.
    - SSL required: Uncheck.
   

   

   • Cloud Hadoop version 1.9 or lower

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

   

Check tables and records

1. Click [Include] and search to check the tables in the schema.
   

2. Click [Update now] to load the data into the tables.
   

3. You can create a new sheet and visualize it simply by dragging and dropping.