Superset Impala Testing

Quick Datagen in Impala

Create some dummy data in Impala.

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

---

Configure Superset

Example URL:

impala://{impala-daemon}:21050/default?auth_mechanism=GSSAPI&kerberos_service_name=impala
Here:

impala://newsuper-0.newsuper.harshith.svc.cluster.local:21050/default?auth_mechanism=GSSAPI&kerberos_service_name=impala