Lindorm Compute Engine provides comprehensive Hive data warehousing capabilities. You can use Hive or Spark SQL to write data warehousing jobs. This topic describes how to use SQL to access Hive data.
Prerequisites
The Compute Engine service is activated for your Lindorm instance. For more information, see Activate the service.
Activate the built-in Hive Metastore service
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 left-side navigation pane, choose .
-
On the Hive Metastore tab, click Activate Now.
Examples
The following SQL examples show how to create a table and read from or write to it. For more information about 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;