Skip to main content
This tutorial walks you through how you can upload an ORC file into the NexusOne platform.

​
Prerequisite

Before starting this tutorial, ensure you have the following permissions:
  • nx1_ingest
  • nx1_monitor
  • nx1_s3_admin
  • airflow_user
  • superset_user
  • spark_sql
  • trino_admin

​
Download an ORC file

Use this user dataset provided by team.

​
Upload it to the portal

  1. Log in to NexusOne.
  2. On the NexusOne homepage, navigate to Ingest > File.
  3. In the File Details section, click Upload File > Choose file.

​
Add ingest details

Add the following information to the fields:
  • Name: orc
  • Schema: orc_schema
  • Table: orc_table
  • Schedule: Run Once
  • Mode: append
  • Tags: Don’t add any tags
After adding these details, click Ingest. Wait for a few minutes until you see a success message appear.

​
Monitor job

When you ingest the file, this creates an Airflow job. To monitor the status of the job, use the following steps:
  1. Click View Jobs or navigate to the NexusOne homepage and click Monitor.
  2. Find your job name, orc, in the list, and watch its current status.
  3. Wait for a few minutes and refresh your browser until the status changes to Completed.

​
Visualize your dataset

Use the following steps to visualize your dataset:
  1. On the NexusOne homepage, click Discover to launch Superset.
  2. Hover your mouse over SQL, and then select SQL Lab.
  3. Enter the following command in the query box:
visualize-orc-dataset-v4-1-2
Visualize your dataset

​
Additional resources