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 shows how to activate Hive Metastore and query data using SQL.
Prerequisites
Before you begin, ensure that you have:
The compute engine enabled for your Lindorm instance. See Enable the service
Activate Hive Metastore
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.
In the navigation pane on the left, choose Compute Engine > Service Management.
On the Hive Metastore tab, click Activate Now.
Query data with SQL
All examples use spark_catalog as the catalog and demonstrate a complete table lifecycle: create, insert, and query. For the full SQL syntax reference, see Spark 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;