Acceldata
 ODP
Search documentation… ⌘K

Superset Hive Testing

We can use the same dataset we created in Impala testing, and create it in HIVE.

CREATE DATABASE IF NOT EXISTS test_superset_hive;
USE test_superset_hive;
CREATE TABLE IF NOT EXISTS test_table (
id INT,
country STRING,
sales DOUBLE,
sale_timestamp TIMESTAMP
);
INSERT INTO test_superset_hive.test_table
SELECT 1,'India',120,'2025-02-01 10:00:00' UNION ALL
SELECT 2,'USA',200,'2025-02-01 11:00:00' UNION ALL
SELECT 3,'UK',150,'2025-02-01 12:00:00' UNION ALL
SELECT 4,'Germany',300,'2025-02-01 13:00:00' UNION ALL
SELECT 5,'France',180,'2025-02-01 14:00:00' UNION ALL
SELECT 6,'Canada',90,'2025-02-01 15:00:00' UNION ALL
SELECT 7,'India',220,'2025-02-02 10:00:00' UNION ALL
SELECT 8,'USA',180,'2025-02-02 11:00:00' UNION ALL
SELECT 9,'UK',170,'2025-02-02 12:00:00' UNION ALL
SELECT 10,'Germany',310,'2025-02-02 13:00:00' UNION ALL
SELECT 11,'France',200,'2025-02-02 14:00:00' UNION ALL
SELECT 12,'Canada',95,'2025-02-02 15:00:00' UNION ALL
SELECT 13,'India',250,'2025-02-03 10:00:00' UNION ALL
SELECT 14,'USA',210,'2025-02-03 11:00:00' UNION ALL
SELECT 15,'UK',140,'2025-02-03 12:00:00' UNION ALL
SELECT 16,'Germany',330,'2025-02-03 13:00:00' UNION ALL
SELECT 17,'France',220,'2025-02-03 14:00:00' UNION ALL
SELECT 18,'Canada',100,'2025-02-03 15:00:00' UNION ALL
SELECT 19,'India',300,'2025-02-04 10:00:00' UNION ALL
SELECT 20,'USA',190,'2025-02-04 11:00:00' UNION ALL
SELECT 21,'UK',160,'2025-02-04 12:00:00' UNION ALL
SELECT 22,'Germany',350,'2025-02-04 13:00:00' UNION ALL
SELECT 23,'France',210,'2025-02-04 14:00:00' UNION ALL
SELECT 24,'Canada',120,'2025-02-04 15:00:00' UNION ALL
SELECT 25,'India',280,'2025-02-05 10:00:00' UNION ALL
SELECT 26,'USA',230,'2025-02-05 11:00:00' UNION ALL
SELECT 27,'UK',180,'2025-02-05 12:00:00' UNION ALL
SELECT 28,'Germany',370,'2025-02-05 13:00:00' UNION ALL
SELECT 29,'France',240,'2025-02-05 14:00:00' UNION ALL
SELECT 30,'Canada',130,'2025-02-05 15:00:00' UNION ALL
SELECT 31,'India',320,'2025-02-06 10:00:00' UNION ALL
SELECT 32,'USA',260,'2025-02-06 11:00:00' UNION ALL
SELECT 33,'UK',200,'2025-02-06 12:00:00' UNION ALL
SELECT 34,'Germany',390,'2025-02-06 13:00:00' UNION ALL
SELECT 35,'France',260,'2025-02-06 14:00:00' UNION ALL
SELECT 36,'Canada',140,'2025-02-06 15:00:00' UNION ALL
SELECT 37,'India',350,'2025-02-07 10:00:00' UNION ALL
SELECT 38,'USA',270,'2025-02-07 11:00:00' UNION ALL
SELECT 39,'UK',210,'2025-02-07 12:00:00' UNION ALL
SELECT 40,'Germany',410,'2025-02-07 13:00:00' UNION ALL
SELECT 41,'France',280,'2025-02-07 14:00:00' UNION ALL
SELECT 42,'Canada',150,'2025-02-07 15:00:00' UNION ALL
SELECT 43,'India',370,'2025-02-08 10:00:00' UNION ALL
SELECT 44,'USA',290,'2025-02-08 11:00:00' UNION ALL
SELECT 45,'UK',220,'2025-02-08 12:00:00' UNION ALL
SELECT 46,'Germany',430,'2025-02-08 13:00:00' UNION ALL
SELECT 47,'France',300,'2025-02-08 14:00:00' UNION ALL
SELECT 48,'Canada',160,'2025-02-08 15:00:00' UNION ALL
SELECT 49,'India',400,'2025-02-09 10:00:00' UNION ALL
SELECT 50,'USA',310,'2025-02-09 11:00:00' UNION ALL
SELECT 51,'UK',240,'2025-02-09 12:00:00' UNION ALL
SELECT 52,'Germany',450,'2025-02-09 13:00:00' UNION ALL
SELECT 53,'France',320,'2025-02-09 14:00:00' UNION ALL
SELECT 54,'Canada',170,'2025-02-09 15:00:00' UNION ALL
SELECT 55,'India',420,'2025-02-10 10:00:00' UNION ALL
SELECT 56,'USA',330,'2025-02-10 11:00:00' UNION ALL
SELECT 57,'UK',260,'2025-02-10 12:00:00' UNION ALL
SELECT 58,'Germany',480,'2025-02-10 13:00:00' UNION ALL
SELECT 59,'France',350,'2025-02-10 14:00:00' UNION ALL
SELECT 60,'Canada',180,'2025-02-10 15:00:00';

Configure Superset

Example URL:

hive://{hive server 2}:10000/default?auth=KERBEROS&kerberos_service_name=hive
URL for the following cluster:

hive://newsuper-1.newsuper.harshith.svc.cluster.local:10000/default?auth=KERBEROS&kerberos_service_name=hive

Dataset > Create Dataset

Create a chart