--create schema test;
use test;

--Get and load set of SQL random functions:
--wget https://raw.githubusercontent.com/mariadb-edwardstoever/f_random_functions/main/f_random_functions.sql
--source f_random_functions.sql;

--CREATE TABLE `LTE_HIST_MESH3_DAILY` (
CREATE TABLE t1 (
 `Type` varchar(55) DEFAULT NULL,
 `Part` tinyint(3) unsigned DEFAULT NULL,
 `Cluster` varchar(200) DEFAULT NULL,
 `AggKey` varchar(100) DEFAULT NULL,
 `Date` date DEFAULT NULL,
 `TimeZone` varchar(50) DEFAULT NULL,
 `RowsAggregated` int(11) DEFAULT NULL,
 `LevelID` smallint(6) DEFAULT NULL,
 `Longitude` decimal(9,6) DEFAULT NULL,
 `Latitude` decimal(9,6) DEFAULT NULL,
 `ElementID` int(10) unsigned DEFAULT NULL,
 `DL_EARFCN` int(11) DEFAULT NULL,
 `Coverage` varchar(35) DEFAULT NULL,
 `histType` varchar(50) DEFAULT NULL,
 `dimValue` bigint(20) DEFAULT NULL,
 `dimCount` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
;

--insert ~500 rows into table using random function:
INSERT INTO t1 (
    `Type`, `Part`, `Cluster`, `AggKey`, `Date`, `TimeZone`, 
    `RowsAggregated`, `LevelID`, `Longitude`, `Latitude`, 
    `ElementID`, `DL_EARFCN`, `Coverage`, `histType`, `dimValue`, `dimCount`
)
SELECT 
    'LTE',                                       -- Type
    2,                                           -- Part
    F_RANDOM_CITY(),                             -- Cluster
    'AGG',                                       -- AggKey
    '2021-08-04',                                -- Date
    F_RANDOM_ENUM('EST,PST,GMT,UTC'),            -- TimeZone
    F_RANDOM_INTEGER(1, 100),                    -- RowsAggregated
    -1003,                                       -- LevelID
    -112.508500,                                 -- Longitude
    33.474500,                                   -- Latitude
    1001,                                        -- ElementID
    F_RANDOM_INTEGER(500, 505),                  -- DL_EARFCN
    'Outdoor',                                   -- Coverage
    -- FIX: Passed as a single string argument
    F_RANDOM_ENUM('CE_BestPCICount,CE_LTEServingSectorHandleCount,CE_MDTBestPCICount,CE_MDTServingPCICount,CE_MDTServingSectorHandleCount,CE_ServingPCICount'), 
    F_RANDOM_INTEGER(1, 50),                     -- dimValue
    F_RANDOM_FLOAT(1, 500, 2)                    -- dimCount
FROM 
    (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10) a
    CROSS JOIN 
    (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10) b
    CROSS JOIN 
    (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5) c;