The Lindorm compute engine provides comprehensive Hive data warehouse capabilities. You can use Hive or Spark SQL to define data warehouse processing logic and develop jobs. This topic describes how to access Hive data using SQL.
Prerequisites
The compute engine is enabled for your Lindorm instance. For more information, see Enable the service.
Activation steps
Log on to the Lindorm console.
In the upper-left corner of the page, select the region where the instance is deployed.
On the Instances page, click the ID of the target instance or click View Instance Details in the Actions column for the instance.
In the navigation pane on the left, choose .
On the Hive Metastore tab, click Activate Now.
Examples
The following SQL examples show how to create a table and read and write data. For more information about the SQL syntax, see SQL Reference.
USE spark_catalog;
CREATE TABLE test (id INT, name STRING, score DOUBLE);
INSERT INTO test VALUES (0, 'Jay', 90.8);
SELECT * FROM test;