View result

Available in VPC

This guide describes how to view and download the result of query executions and how to change its storage location.

View query results

Once query execution has been completed, its result is displayed in the result component. Information that can be viewed in each tab is as follows:

Tab	Description
[Result] tab	Displays the query execution status and results, and shows the reason for failure if the query execution fails. Status QUEUED: The query is authorized and waiting to be executed. STARTING: The query execution has started. RUNNING: The query is being executed. FINISHED: The query execution completed successfully. FAILED: The query execution failed. CANCELED: The query execution was canceled before completion. [Download]: Go to the Object Storage bucket storing the query results.
[Details] tab	Find detailed information about the query execution here (see View details).
[Execution structure diagram] tab	Click to open the execution structure diagram, where you can view query execution details for each stage (see View execution structure diagram).
[Chart] tab	Select properties for the X-axis and Y-axis to view the query result in a chart form (see Configure chart). [Download image]: Download the chart as a PNG file.

Note

Up to 10 MB of the query results from the Query Editor console interface can be accessed in the [Result] tab. To see the whole query results, use the provided services such as Data Query CLI/JDBC or connect external BI.

Configure chart

With additional configurations, you can see the query execution result in a chart form. After seeing the chart, click the [Download image] to download it in the PNG format.
Items to configure to see the chart and their descriptions are as follows:

Note

Once the properties for the X-axis and the Y-axis are selected, the chart appears immediately on the left side of the chart configuration component.

Item	Description
Chart types	Types of charts used to display results Line: Line chart Area: Area chart Bar: Bar chart
X-axis	Attribute displayed on the horizontal axis among the result attributes Attributes of all data types selectable Multiple selection not supported
X-axis label	Description of the X-axis data
Y-axis	Attributes displayed on the vertical axis Only numeric attributes selectable Multiple selection not supported
Y-axis label	Description of the Y-axis data
Chart title	Title of the chart

Number data type: BIGINT, BIGSERIAL, BIT, DECIMAL, DECIMAL128, DOUBLE, DOUBLE PRECISION, FLOAT, INT, INT32, INTEGER, LONG, MEDIUMINT, MONEY, NUMERIC, REAL, SERIAL, SMALLINT, SMALLMONEY, SMALLSERIAL, and TINYINT

Download results

Once query execution has been completed, its result is displayed in the [Result] tab in the result component, enabling the [Download]. Clicking the [Download] opens a new window showing a bucket where the results are stored. You can then download the results in the CSV format. For more information on how to download from the bucket, see Download file.

Note

As a query simulation does not result in valid query results, the [Download] is disabled and no results can be downloaded.
The [Download] is only enabled when the query execution is completed successfully.

Change result storage location

By default, query results are automatically stored in a dedicated bucket, but the storage location can be changed. To change it, follow these steps:

In the VPC environment on the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Query.
Click the Query Editor menu.
Click .
In the configuration popup, click [Specify location].
In the Object Storage location popup, select the save location and click [Save].
Click [Save].
- Subsequent query results are now stored in the updated location.