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

Prerequisite

Appropriate permission: nx1_ingest

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: None
  • Mode: append
  • Tags: Don’t add any tags
For the Schedule field, None specifies that the DAG on Apache Airflow won’t rerun. After adding these details, click Ingest. Wait for a few minutes until you see a success message appear.
The DAG automatically runs on the first schedule. Recurrent runs depend on your selected schedule option.

Monitor job

After the success message from the previous instruction appears, click View Jobs or navigate to the NexusOne homepage and click Monitor. You should see your job name, orc, in the list, and its current status.

Visualize your dataset

On the NexusOne homepage, navigate to Discover > New > SQL query. Then execute the following command:
SELECT * FROM orc_schema.orc_table
visualize-orc-dataset-mtb58

Visualize your dataset

Additional resources