CREATE TABLE IF NOT EXISTS MY_TABLE
(
 KEY_1            UNSIGNED_INT NOT NULL
 ,KEY_2             DATE NOT NULL
 ,KEY_3           UNSIGNED_LONG NOT NULL
 ,KEY_4              UNSIGNED_LONG NOT NULL
 ,CALENDAR_DATE              DATE
 ,SOURCE_ID             UNSIGNED_INT
 ,COL_1            UNSIGNED_INT
 ,COL_2               UNSIGNED_INT
 ,DS_ID              UNSIGNED_INT
 ,START_TIME       TIMESTAMP
 ,END_TIME         TIMESTAMP
 ,COL_3              UNSIGNED_INT
 ,EVENT_START_TIME      TIMESTAMP
 ,EVENT_END_TIME       TIMESTAMP
 ,EVENT_TYPE                VARCHAR(50)
 ,EVENT_CODE                   UNSIGNED_INT
 ,COL_4               DATE
 ,COL_5 TIMESTAMP
 ,COL_6   TIMESTAMP 
 CONSTRAINT PK PRIMARY KEY (KEY_1, KEY_2, KEY_3, KEY_4)
) COMPRESSION='SNAPPY';


SELECT 
  KEY_1
  ,KEY_2
  ,COL_1
  ,COL_2
  ,DS_ID
  ,START_TIME
  ,END_TIME
  ,COL_3
  ,EVENT_START_TIME
  ,EVENT_END_TIME
  ,EVENT_TYPE
  ,EVENT_CODE
  ,COL_4
  ,COL_5
  ,COL_6
FROM
  MY_TABLE LIMIT 100000;