Superset Hive Testing

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';

hive://{hive server 2}:10000/default?auth=KERBEROS&kerberos_service_name=hive

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