Superset Impala Testing

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

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