[GitHub] [pinot] xiangfu0 commented on a diff in pull request #10561: 10459: Change H2 __MV columns to Array DataType

[via GitHub]

xiangfu0 commented on code in PR #10561:
URL: https://github.com/apache/pinot/pull/10561#discussion_r1161072781


##########
pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_200.sql:
##########
@@ -117,54 +117,54 @@
 {"sql":"SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable GROUP BY 
WheelsOn, OriginStateName  ORDER BY WheelsOn, OriginStateName LIMIT 
18","hsqls":["SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable 
GROUP BY WheelsOn, OriginStateName  ORDER BY WheelsOn, OriginStateName LIMIT 
18"]}
 
 # Filtering on Aggregation
-{"sql":"SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE 
DivTailNums BETWEEN 'N8315C' AND 'N130DL' OR DivAirports IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT') AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 
5","hsqls":["SELECT AVG(AirTime), SUM(OriginStateFips)  FROM mytable WHERE 
(DivTailNums__MV0 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV1 BETWEEN 
'N8315C' AND 'N130DL' OR DivTailNums__MV2 BETWEEN 'N8315C' AND 'N130DL' OR 
DivTailNums__MV3 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV4 BETWEEN 
'N8315C' AND 'N130DL') OR (DivAirports__MV0 IN ('PIH', 'DLH', 'MTJ', 'SEA', 
'LIT') OR DivAirports__MV1 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR 
DivAirports__MV2 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV3 IN 
('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV4 IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT')) AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 10000"]}
-{"sql":"SELECT AVG(ArrDel15) FROM mytable WHERE DivWheelsOffs >= 1610 LIMIT 
13","hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable WHERE 
(DivWheelsOffs__MV0 >= 1610 OR DivWheelsOffs__MV1 >= 1610 OR DivWheelsOffs__MV2 
>= 1610 OR DivWheelsOffs__MV3 >= 1610 OR DivWheelsOffs__MV4 >= 1610) LIMIT 
10000"]}
+{"sql":"SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE 
DivTailNums BETWEEN 'N8315C' AND 'N130DL' OR DivAirports IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT') AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 
5","hsqls":["SELECT AVG(AirTime), SUM(OriginStateFips)  FROM mytable WHERE 
(DivTailNums[1] BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums[2] BETWEEN 
'N8315C' AND 'N130DL' OR DivTailNums[3] BETWEEN 'N8315C' AND 'N130DL' OR 
DivTailNums[4] BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums[5] BETWEEN 'N8315C' 
AND 'N130DL') OR (DivAirports[1] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR 
DivAirports[2] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports[3] IN 
('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports[4] IN ('PIH', 'DLH', 'MTJ', 
'SEA', 'LIT') OR DivAirports[5] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT')) AND 
TaxiOut NOT IN (59, 112, 57, 72) LIMIT 10000"]}
+{"sql":"SELECT AVG(ArrDel15) FROM mytable WHERE DivWheelsOffs >= 1610 LIMIT 
13","hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable WHERE 
(DivWheelsOffs[1] >= 1610 OR DivWheelsOffs[2] >= 1610 OR DivWheelsOffs[3] >= 
1610 OR DivWheelsOffs[4] >= 1610 OR DivWheelsOffs[5] >= 1610) LIMIT 10000"]}
 {"sql":"SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE 
\"Year\" = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 
22","hsqls":["SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE 
`Year` = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 
22"]}
 {"sql":"SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) FROM 
mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 
14","hsqls":["SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) 
FROM mytable WHERE `Year` BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 
14"]}
-{"sql":"SELECT AVG(DayOfWeek) FROM mytable WHERE DivTailNums IN ('N915DE', 
'N8612K') LIMIT 3","hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable 
WHERE (DivTailNums__MV0 IN ('N915DE', 'N8612K') OR DivTailNums__MV1 IN 
('N915DE', 'N8612K') OR DivTailNums__MV2 IN ('N915DE', 'N8612K') OR 
DivTailNums__MV3 IN ('N915DE', 'N8612K') OR DivTailNums__MV4 IN ('N915DE', 
'N8612K')) LIMIT 10000"]}
-{"sql":"SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE 
DivAirportSeqIDs >= 1281902 OR DestAirportSeqID NOT IN (1463502, 1530402, 
1068502) AND DepDelayMinutes BETWEEN 48.0 AND 94.0 LIMIT 18","hsqls":["SELECT 
AVG(DayOfWeek), MAX(Diverted)  FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 
1281902 OR DivAirportSeqIDs__MV1 >= 1281902 OR DivAirportSeqIDs__MV2 >= 1281902 
OR DivAirportSeqIDs__MV3 >= 1281902 OR DivAirportSeqIDs__MV4 >= 1281902) OR 
DestAirportSeqID NOT IN (1463502, 1530402, 1068502) AND DepDelayMinutes BETWEEN 
48.0 AND 94.0 LIMIT 10000"]}
+{"sql":"SELECT AVG(DayOfWeek) FROM mytable WHERE DivTailNums IN ('N915DE', 
'N8612K') LIMIT 3","hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable 
WHERE (DivTailNums[1] IN ('N915DE', 'N8612K') OR DivTailNums[2] IN ('N915DE', 
'N8612K') OR DivTailNums[3] IN ('N915DE', 'N8612K') OR DivTailNums[4] IN 
('N915DE', 'N8612K') OR DivTailNums[5] IN ('N915DE', 'N8612K')) LIMIT 10000"]}
+{"sql":"SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE 
DivAirportSeqIDs >= 1281902 OR DestAirportSeqID NOT IN (1463502, 1530402, 
1068502) AND DepDelayMinutes BETWEEN 48.0 AND 94.0 LIMIT 18","hsqls":["SELECT 
AVG(DayOfWeek), MAX(Diverted)  FROM mytable WHERE (DivAirportSeqIDs[1] >= 
1281902 OR DivAirportSeqIDs[2] >= 1281902 OR DivAirportSeqIDs[3] >= 1281902 OR 
DivAirportSeqIDs[4] >= 1281902 OR DivAirportSeqIDs[5] >= 1281902) OR 
DestAirportSeqID NOT IN (1463502, 1530402, 1068502) AND DepDelayMinutes BETWEEN 
48.0 AND 94.0 LIMIT 10000"]}
 {"sql":"SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE 
LateAircraftDelay BETWEEN 151 AND 72 OR \"Year\" IN (2014) LIMIT 
14","hsqls":["SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE 
LateAircraftDelay BETWEEN 151 AND 72 OR `Year` IN (2014) LIMIT 14"]}
-{"sql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DivAirportIDs > 14027 
AND DivLongestGTimes >= 61.0 AND Cancelled BETWEEN 0 AND 1 LIMIT 
3","hsqls":["SELECT AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE 
(DivAirportIDs__MV0 > 14027 OR DivAirportIDs__MV1 > 14027 OR DivAirportIDs__MV2 
> 14027 OR DivAirportIDs__MV3 > 14027 OR DivAirportIDs__MV4 > 14027) AND 
(DivLongestGTimes__MV0 >= 61.0 OR DivLongestGTimes__MV1 >= 61.0 OR 
DivLongestGTimes__MV2 >= 61.0 OR DivLongestGTimes__MV3 >= 61.0 OR 
DivLongestGTimes__MV4 >= 61.0) AND Cancelled BETWEEN 0 AND 1 LIMIT 10000"]}
+{"sql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DivAirportIDs > 14027 
AND DivLongestGTimes >= 61.0 AND Cancelled BETWEEN 0 AND 1 LIMIT 
3","hsqls":["SELECT AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE 
(DivAirportIDs[1] > 14027 OR DivAirportIDs[2] > 14027 OR DivAirportIDs[3] > 
14027 OR DivAirportIDs[4] > 14027 OR DivAirportIDs[5] > 14027) AND 
(DivLongestGTimes[1] >= 61.0 OR DivLongestGTimes[2] >= 61.0 OR 
DivLongestGTimes[3] >= 61.0 OR DivLongestGTimes[4] >= 61.0 OR 
DivLongestGTimes[5] >= 61.0) AND Cancelled BETWEEN 0 AND 1 LIMIT 10000"]}
 {"sql":"SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM mytable WHERE 
\"Year\" NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND DayOfWeek NOT IN 
(6, 5) LIMIT 15","hsqls":["SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM 
mytable WHERE `Year` NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND 
DayOfWeek NOT IN (6, 5) LIMIT 15"]}
-{"sql":"SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) 
FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR DivWheelsOffs 
BETWEEN 1719 AND 1720 LIMIT 16","hsqls":["SELECT AVG(TotalAddGTime), 
SUM(ArrivalDelayGroups), SUM(SecurityDelay)  FROM mytable WHERE UniqueCarrier = 
'AA' OR Cancelled IN (1, 0) OR (DivWheelsOffs__MV0 BETWEEN 1719 AND 1720 OR 
DivWheelsOffs__MV1 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV2 BETWEEN 1719 AND 
1720 OR DivWheelsOffs__MV3 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV4 BETWEEN 
1719 AND 1720) LIMIT 10000"]}
-{"sql":"SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 
OR DivAirports >= 'SIT' OR OriginWac BETWEEN 1 AND 71 LIMIT 
21","hsqls":["SELECT AVG(WeatherDelay), MIN(ArrTime)  FROM mytable WHERE TaxiIn 
< 162 OR (DivAirports__MV0 >= 'SIT' OR DivAirports__MV1 >= 'SIT' OR 
DivAirports__MV2 >= 'SIT' OR DivAirports__MV3 >= 'SIT' OR DivAirports__MV4 >= 
'SIT') OR OriginWac BETWEEN 1 AND 71 LIMIT 10000"]}
-{"sql":"SELECT AVG(\"Year\"), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1702, 2226, 749, 
2328, 844) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 
2","hsqls":["SELECT AVG(`Year`), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups)  FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 
2226, 749, 2328, 844) OR DivWheelsOffs__MV1 IN (1702, 2226, 749, 2328, 844) OR 
DivWheelsOffs__MV2 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV3 IN 
(1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV4 IN (1702, 2226, 749, 2328, 
844)) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000"]}
-{"sql":"SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 
247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND DivAirportSeqIDs BETWEEN 
1252302 AND 1232303 LIMIT 4","hsqls":["SELECT COUNT(*) FROM mytable WHERE 
ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 
AND 4 AND (DivAirportSeqIDs__MV0 BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs__MV1 BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV2 
BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV3 BETWEEN 1252302 AND 
1232303 OR DivAirportSeqIDs__MV4 BETWEEN 1252302 AND 1232303) LIMIT 10000"]}
-{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR DivTailNums > 
'N854AS' AND DayOfWeek NOT IN (3, 1, 6) LIMIT 15","hsqls":["SELECT COUNT(*) 
FROM mytable WHERE CRSArrTime <> 1940 OR (DivTailNums__MV0 > 'N854AS' OR 
DivTailNums__MV1 > 'N854AS' OR DivTailNums__MV2 > 'N854AS' OR DivTailNums__MV3 
> 'N854AS' OR DivTailNums__MV4 > 'N854AS') AND DayOfWeek NOT IN (3, 1, 6) LIMIT 
10000"]}
+{"sql":"SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) 
FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR DivWheelsOffs 
BETWEEN 1719 AND 1720 LIMIT 16","hsqls":["SELECT AVG(TotalAddGTime), 
SUM(ArrivalDelayGroups), SUM(SecurityDelay)  FROM mytable WHERE UniqueCarrier = 
'AA' OR Cancelled IN (1, 0) OR (DivWheelsOffs[1] BETWEEN 1719 AND 1720 OR 
DivWheelsOffs[2] BETWEEN 1719 AND 1720 OR DivWheelsOffs[3] BETWEEN 1719 AND 
1720 OR DivWheelsOffs[4] BETWEEN 1719 AND 1720 OR DivWheelsOffs[5] BETWEEN 1719 
AND 1720) LIMIT 10000"]}
+{"sql":"SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 
OR DivAirports >= 'SIT' OR OriginWac BETWEEN 1 AND 71 LIMIT 
21","hsqls":["SELECT AVG(WeatherDelay), MIN(ArrTime)  FROM mytable WHERE TaxiIn 
< 162 OR (DivAirports[1] >= 'SIT' OR DivAirports[2] >= 'SIT' OR DivAirports[3] 
>= 'SIT' OR DivAirports[4] >= 'SIT' OR DivAirports[5] >= 'SIT') OR OriginWac 
BETWEEN 1 AND 71 LIMIT 10000"]}
+{"sql":"SELECT AVG(\"Year\"), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1702, 2226, 749, 
2328, 844) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 
2","hsqls":["SELECT AVG(`Year`), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups)  FROM mytable WHERE (DivWheelsOffs[1] IN (1702, 2226, 
749, 2328, 844) OR DivWheelsOffs[2] IN (1702, 2226, 749, 2328, 844) OR 
DivWheelsOffs[3] IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs[4] IN (1702, 
2226, 749, 2328, 844) OR DivWheelsOffs[5] IN (1702, 2226, 749, 2328, 844)) OR 
ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 
247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND DivAirportSeqIDs BETWEEN 
1252302 AND 1232303 LIMIT 4","hsqls":["SELECT COUNT(*) FROM mytable WHERE 
ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 
AND 4 AND (DivAirportSeqIDs[1] BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs[2] BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs[3] BETWEEN 
1252302 AND 1232303 OR DivAirportSeqIDs[4] BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs[5] BETWEEN 1252302 AND 1232303) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR DivTailNums > 
'N854AS' AND DayOfWeek NOT IN (3, 1, 6) LIMIT 15","hsqls":["SELECT COUNT(*) 
FROM mytable WHERE CRSArrTime <> 1940 OR (DivTailNums[1] > 'N854AS' OR 
DivTailNums[2] > 'N854AS' OR DivTailNums[3] > 'N854AS' OR DivTailNums[4] > 
'N854AS' OR DivTailNums[5] > 'N854AS') AND DayOfWeek NOT IN (3, 1, 6) LIMIT 
10000"]}
 {"sql":"SELECT COUNT(*) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR 
DepTimeBlk BETWEEN '1400-1459' AND '1300-1359' LIMIT 8","hsqls":["SELECT 
COUNT(*) FROM mytable WHERE `Year` BETWEEN 2014 AND 2014 OR DepTimeBlk BETWEEN 
'1400-1459' AND '1300-1359' LIMIT 8"]}
-{"sql":"SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR DivTotalGTimes IN (62) LIMIT 
18","hsqls":["SELECT COUNT(ActualElapsedTime), AVG(DestWac)  FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR (DivTotalGTimes__MV0 IN (62) OR 
DivTotalGTimes__MV1 IN (62) OR DivTotalGTimes__MV2 IN (62) OR 
DivTotalGTimes__MV3 IN (62) OR DivTotalGTimes__MV4 IN (62)) LIMIT 10000"]}
-{"sql":"SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR 
DivWheelsOffs BETWEEN 2043 AND 2133 AND FlightNum NOT IN (3228) LIMIT 
11","hsqls":["SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 
0 OR (DivWheelsOffs__MV0 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV1 BETWEEN 
2043 AND 2133 OR DivWheelsOffs__MV2 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV3 
BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV4 BETWEEN 2043 AND 2133) AND 
FlightNum NOT IN (3228) LIMIT 10000"]}
-{"sql":"SELECT COUNT(CRSElapsedTime) FROM mytable WHERE DivWheelsOffs BETWEEN 
1257 AND 325 AND DestState IN ('LA', 'MS') AND \"Month\" BETWEEN 1 AND 1 LIMIT 
6","hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable WHERE 
(DivWheelsOffs__MV0 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV1 BETWEEN 1257 AND 
325 OR DivWheelsOffs__MV2 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV3 BETWEEN 
1257 AND 325 OR DivWheelsOffs__MV4 BETWEEN 1257 AND 325) AND DestState IN 
('LA', 'MS') AND `Month` BETWEEN 1 AND 1 LIMIT 10000"]}
-{"sql":"SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) 
FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 
OR DivTotalGTimes BETWEEN 57 AND 76","hsqls":["SELECT COUNT(Carrier), 
MIN(DivActualElapsedTime), MAX(DepDelayMinutes)  FROM mytable WHERE 
DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR 
(DivTotalGTimes__MV0 BETWEEN 57 AND 76 OR DivTotalGTimes__MV1 BETWEEN 57 AND 76 
OR DivTotalGTimes__MV2 BETWEEN 57 AND 76 OR DivTotalGTimes__MV3 BETWEEN 57 AND 
76 OR DivTotalGTimes__MV4 BETWEEN 57 AND 76) LIMIT 10000"]}
-{"sql":"SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE 
DaysSinceEpoch <= 16073 AND DivAirportIDs IN (12278, 12451, 11973, 13424) LIMIT 
15","hsqls":["SELECT COUNT(CarrierDelay), SUM(DestAirportID)  FROM mytable 
WHERE DaysSinceEpoch <= 16073 AND (DivAirportIDs__MV0 IN (12278, 12451, 11973, 
13424) OR DivAirportIDs__MV1 IN (12278, 12451, 11973, 13424) OR 
DivAirportIDs__MV2 IN (12278, 12451, 11973, 13424) OR DivAirportIDs__MV3 IN 
(12278, 12451, 11973, 13424) OR DivAirportIDs__MV4 IN (12278, 12451, 11973, 
13424)) LIMIT 10000"]}
-{"sql":"SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) 
FROM mytable WHERE DivAirportSeqIDs < 1234302 LIMIT 26","hsqls":["SELECT 
COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups)  FROM mytable 
WHERE (DivAirportSeqIDs__MV0 < 1234302 OR DivAirportSeqIDs__MV1 < 1234302 OR 
DivAirportSeqIDs__MV2 < 1234302 OR DivAirportSeqIDs__MV3 < 1234302 OR 
DivAirportSeqIDs__MV4 < 1234302) LIMIT 10000"]}
-{"sql":"SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable 
WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND DivAirportIDs <= 
14006 LIMIT 22","hsqls":["SELECT COUNT(OriginCityMarketID), 
MAX(DestCityMarketID)  FROM mytable WHERE Quarter NOT IN (1) OR Distance 
BETWEEN 1454 AND 196 AND (DivAirportIDs__MV0 <= 14006 OR DivAirportIDs__MV1 <= 
14006 OR DivAirportIDs__MV2 <= 14006 OR DivAirportIDs__MV3 <= 14006 OR 
DivAirportIDs__MV4 <= 14006) LIMIT 10000"]}
-{"sql":"SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 
'A' AND 'A' AND DivTailNums BETWEEN 'N397DA' AND 'N940DN' LIMIT 
5","hsqls":["SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode 
BETWEEN 'A' AND 'A' AND (DivTailNums__MV0 BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums__MV1 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV2 BETWEEN 
'N397DA' AND 'N940DN' OR DivTailNums__MV3 BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums__MV4 BETWEEN 'N397DA' AND 'N940DN') LIMIT 10000"]}
-{"sql":"SELECT COUNT(\"Month\"), SUM(OriginAirportSeqID), MIN(AirlineID) FROM 
mytable WHERE DivTailNums <= 'N530MQ' AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 2","hsqls":["SELECT 
COUNT(`Month`), SUM(OriginAirportSeqID), MIN(AirlineID)  FROM mytable WHERE 
(DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR 
DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' OR 
DivTailNums__MV4 <= 'N530MQ') AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 10000"]}
-{"sql":"SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
DivTailNums IN ('N713SK') AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 
10","hsqls":["SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
(DivTailNums__MV0 IN ('N713SK') OR DivTailNums__MV1 IN ('N713SK') OR 
DivTailNums__MV2 IN ('N713SK') OR DivTailNums__MV3 IN ('N713SK') OR 
DivTailNums__MV4 IN ('N713SK')) AND DivActualElapsedTime BETWEEN 153 AND 1043 
LIMIT 10000"]}
+{"sql":"SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR DivTotalGTimes IN (62) LIMIT 
18","hsqls":["SELECT COUNT(ActualElapsedTime), AVG(DestWac)  FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR (DivTotalGTimes[1] IN (62) OR 
DivTotalGTimes[2] IN (62) OR DivTotalGTimes[3] IN (62) OR DivTotalGTimes[4] IN 
(62) OR DivTotalGTimes[5] IN (62)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR 
DivWheelsOffs BETWEEN 2043 AND 2133 AND FlightNum NOT IN (3228) LIMIT 
11","hsqls":["SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 
0 OR (DivWheelsOffs[1] BETWEEN 2043 AND 2133 OR DivWheelsOffs[2] BETWEEN 2043 
AND 2133 OR DivWheelsOffs[3] BETWEEN 2043 AND 2133 OR DivWheelsOffs[4] BETWEEN 
2043 AND 2133 OR DivWheelsOffs[5] BETWEEN 2043 AND 2133) AND FlightNum NOT IN 
(3228) LIMIT 10000"]}
+{"sql":"SELECT COUNT(CRSElapsedTime) FROM mytable WHERE DivWheelsOffs BETWEEN 
1257 AND 325 AND DestState IN ('LA', 'MS') AND \"Month\" BETWEEN 1 AND 1 LIMIT 
6","hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable WHERE (DivWheelsOffs[1] 
BETWEEN 1257 AND 325 OR DivWheelsOffs[2] BETWEEN 1257 AND 325 OR 
DivWheelsOffs[3] BETWEEN 1257 AND 325 OR DivWheelsOffs[4] BETWEEN 1257 AND 325 
OR DivWheelsOffs[5] BETWEEN 1257 AND 325) AND DestState IN ('LA', 'MS') AND 
`Month` BETWEEN 1 AND 1 LIMIT 10000"]}
+{"sql":"SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) 
FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 
OR DivTotalGTimes BETWEEN 57 AND 76","hsqls":["SELECT COUNT(Carrier), 
MIN(DivActualElapsedTime), MAX(DepDelayMinutes)  FROM mytable WHERE 
DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR 
(DivTotalGTimes[1] BETWEEN 57 AND 76 OR DivTotalGTimes[2] BETWEEN 57 AND 76 OR 
DivTotalGTimes[3] BETWEEN 57 AND 76 OR DivTotalGTimes[4] BETWEEN 57 AND 76 OR 
DivTotalGTimes[5] BETWEEN 57 AND 76) LIMIT 10000"]}
+{"sql":"SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE 
DaysSinceEpoch <= 16073 AND DivAirportIDs IN (12278, 12451, 11973, 13424) LIMIT 
15","hsqls":["SELECT COUNT(CarrierDelay), SUM(DestAirportID)  FROM mytable 
WHERE DaysSinceEpoch <= 16073 AND (DivAirportIDs[1] IN (12278, 12451, 11973, 
13424) OR DivAirportIDs[2] IN (12278, 12451, 11973, 13424) OR DivAirportIDs[3] 
IN (12278, 12451, 11973, 13424) OR DivAirportIDs[4] IN (12278, 12451, 11973, 
13424) OR DivAirportIDs[5] IN (12278, 12451, 11973, 13424)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) 
FROM mytable WHERE DivAirportSeqIDs < 1234302 LIMIT 26","hsqls":["SELECT 
COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups)  FROM mytable 
WHERE (DivAirportSeqIDs[1] < 1234302 OR DivAirportSeqIDs[2] < 1234302 OR 
DivAirportSeqIDs[3] < 1234302 OR DivAirportSeqIDs[4] < 1234302 OR 
DivAirportSeqIDs[5] < 1234302) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable 
WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND DivAirportIDs <= 
14006 LIMIT 22","hsqls":["SELECT COUNT(OriginCityMarketID), 
MAX(DestCityMarketID)  FROM mytable WHERE Quarter NOT IN (1) OR Distance 
BETWEEN 1454 AND 196 AND (DivAirportIDs[1] <= 14006 OR DivAirportIDs[2] <= 
14006 OR DivAirportIDs[3] <= 14006 OR DivAirportIDs[4] <= 14006 OR 
DivAirportIDs[5] <= 14006) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 
'A' AND 'A' AND DivTailNums BETWEEN 'N397DA' AND 'N940DN' LIMIT 
5","hsqls":["SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode 
BETWEEN 'A' AND 'A' AND (DivTailNums[1] BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums[2] BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums[3] BETWEEN 'N397DA' 
AND 'N940DN' OR DivTailNums[4] BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums[5] 
BETWEEN 'N397DA' AND 'N940DN') LIMIT 10000"]}
+{"sql":"SELECT COUNT(\"Month\"), SUM(OriginAirportSeqID), MIN(AirlineID) FROM 
mytable WHERE DivTailNums <= 'N530MQ' AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 2","hsqls":["SELECT 
COUNT(`Month`), SUM(OriginAirportSeqID), MIN(AirlineID)  FROM mytable WHERE 
(DivTailNums[1] <= 'N530MQ' OR DivTailNums[2] <= 'N530MQ' OR DivTailNums[3] <= 
'N530MQ' OR DivTailNums[4] <= 'N530MQ' OR DivTailNums[5] <= 'N530MQ') AND 
AirTime NOT IN (122, 158, 73, 142) OR DestAirportID NOT IN (10423, 13303, 
10581, 10747) LIMIT 10000"]}
+{"sql":"SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
DivTailNums IN ('N713SK') AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 
10","hsqls":["SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
(DivTailNums[1] IN ('N713SK') OR DivTailNums[2] IN ('N713SK') OR DivTailNums[3] 
IN ('N713SK') OR DivTailNums[4] IN ('N713SK') OR DivTailNums[5] IN ('N713SK')) 
AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 10000"]}
 {"sql":"SELECT MAX(ArrDelay), AVG(\"Month\"), MAX(ActualElapsedTime) FROM 
mytable WHERE DepTimeBlk IN ('2000-2059', '1300-1359', '1100-1159', 
'0600-0659', '0800-0859') LIMIT 14","hsqls":["SELECT MAX(ArrDelay), 
AVG(`Month`), MAX(ActualElapsedTime) FROM mytable WHERE DepTimeBlk IN 
('2000-2059', '1300-1359', '1100-1159', '0600-0659', '0800-0859') LIMIT 14"]}
-{"sql":"SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM 
mytable WHERE NASDelay IN (49, 145, 45) AND DivWheelsOffs < 917 AND 
UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 27","hsqls":["SELECT 
MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac)  FROM mytable WHERE 
NASDelay IN (49, 145, 45) AND (DivWheelsOffs__MV0 < 917 OR DivWheelsOffs__MV1 < 
917 OR DivWheelsOffs__MV2 < 917 OR DivWheelsOffs__MV3 < 917 OR 
DivWheelsOffs__MV4 < 917) AND UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 
'VX') LIMIT 10000"]}
+{"sql":"SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM 
mytable WHERE NASDelay IN (49, 145, 45) AND DivWheelsOffs < 917 AND 
UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 27","hsqls":["SELECT 
MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac)  FROM mytable WHERE 
NASDelay IN (49, 145, 45) AND (DivWheelsOffs[1] < 917 OR DivWheelsOffs[2] < 917 
OR DivWheelsOffs[3] < 917 OR DivWheelsOffs[4] < 917 OR DivWheelsOffs[5] < 917) 
AND UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 10000"]}
 {"sql":"SELECT MAX(DivActualElapsedTime), MIN(\"Month\"), AVG(WheelsOff) FROM 
mytable WHERE Diverted NOT IN (1, 0) OR Diverted BETWEEN 0 AND 1 AND 
DestCityMarketID = 31136 LIMIT 27","hsqls":["SELECT MAX(DivActualElapsedTime), 
MIN(`Month`), AVG(WheelsOff) FROM mytable WHERE Diverted NOT IN (1, 0) OR 
Diverted BETWEEN 0 AND 1 AND DestCityMarketID = 31136 LIMIT 27"]}
-{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN 
('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN 
(16071, 16088, 16074, 16078, 16091) OR DivWheelsOns = 1317 LIMIT 
11","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT 
IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch 
IN (16071, 16088, 16074, 16078, 16091) OR (DivWheelsOns__MV0 = 1317 OR 
DivWheelsOns__MV1 = 1317 OR DivWheelsOns__MV2 = 1317 OR DivWheelsOns__MV3 = 
1317 OR DivWheelsOns__MV4 = 1317) LIMIT 10000"]}
-{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 
936) OR DivTotalGTimes > 76 LIMIT 1","hsqls":["SELECT MAX(LongestAddGTime) FROM 
mytable WHERE WheelsOn NOT IN (1659, 936) OR (DivTotalGTimes__MV0 > 76 OR 
DivTotalGTimes__MV1 > 76 OR DivTotalGTimes__MV2 > 76 OR DivTotalGTimes__MV3 > 
76 OR DivTotalGTimes__MV4 > 76) LIMIT 10000"]}
-{"sql":"SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE 
ArrDel15 IN (1, 0, -9999) OR DivLongestGTimes < 57.0 OR DepDelay NOT IN (342.0, 
48.0) LIMIT 25","hsqls":["SELECT MAX(WheelsOff), COUNT(CancellationCode)  FROM 
mytable WHERE ArrDel15 IN (1, 0, -9999) OR (DivLongestGTimes__MV0 < 57.0 OR 
DivLongestGTimes__MV1 < 57.0 OR DivLongestGTimes__MV2 < 57.0 OR 
DivLongestGTimes__MV3 < 57.0 OR DivLongestGTimes__MV4 < 57.0) OR DepDelay NOT 
IN (342.0, 48.0) LIMIT 10000"]}
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN 
('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN 
(16071, 16088, 16074, 16078, 16091) OR DivWheelsOns = 1317 LIMIT 
11","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT 
IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch 
IN (16071, 16088, 16074, 16078, 16091) OR (DivWheelsOns[1] = 1317 OR 
DivWheelsOns[2] = 1317 OR DivWheelsOns[3] = 1317 OR DivWheelsOns[4] = 1317 OR 
DivWheelsOns[5] = 1317) LIMIT 10000"]}
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 
936) OR DivTotalGTimes > 76 LIMIT 1","hsqls":["SELECT MAX(LongestAddGTime) FROM 
mytable WHERE WheelsOn NOT IN (1659, 936) OR (DivTotalGTimes[1] > 76 OR 
DivTotalGTimes[2] > 76 OR DivTotalGTimes[3] > 76 OR DivTotalGTimes[4] > 76 OR 
DivTotalGTimes[5] > 76) LIMIT 10000"]}
+{"sql":"SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE 
ArrDel15 IN (1, 0, -9999) OR DivLongestGTimes < 57.0 OR DepDelay NOT IN (342.0, 
48.0) LIMIT 25","hsqls":["SELECT MAX(WheelsOff), COUNT(CancellationCode)  FROM 
mytable WHERE ArrDel15 IN (1, 0, -9999) OR (DivLongestGTimes[1] < 57.0 OR 
DivLongestGTimes[2] < 57.0 OR DivLongestGTimes[3] < 57.0 OR DivLongestGTimes[4] 
< 57.0 OR DivLongestGTimes[5] < 57.0) OR DepDelay NOT IN (342.0, 48.0) LIMIT 
10000"]}
 {"sql":"SELECT MAX(\"Month\") FROM mytable WHERE CRSDepTime IN (1534, 2213) OR 
DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 LIMIT 
11","hsqls":["SELECT MAX(`Month`) FROM mytable WHERE CRSDepTime IN (1534, 2213) 
OR DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 
LIMIT 11"]}
-{"sql":"SELECT MAX(\"Year\") FROM mytable WHERE DivWheelsOns >= 2058 OR 
UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 
20","hsqls":["SELECT MAX(`Year`) FROM mytable WHERE (DivWheelsOns__MV0 >= 2058 
OR DivWheelsOns__MV1 >= 2058 OR DivWheelsOns__MV2 >= 2058 OR DivWheelsOns__MV3 
>= 2058 OR DivWheelsOns__MV4 >= 2058) OR UniqueCarrier BETWEEN 'VX' AND 'US' OR 
CRSElapsedTime > 290 LIMIT 10000"]}
-{"sql":"SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable 
WHERE DivWheelsOffs >= 2009 AND Diverted >= 1 OR OriginCityMarketID >= 34783 
LIMIT 29","hsqls":["SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek)  
FROM mytable WHERE (DivWheelsOffs__MV0 >= 2009 OR DivWheelsOffs__MV1 >= 2009 OR 
DivWheelsOffs__MV2 >= 2009 OR DivWheelsOffs__MV3 >= 2009 OR DivWheelsOffs__MV4 
>= 2009) AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 10000"]}
-{"sql":"SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable 
WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
DivTailNums IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') LIMIT 
29","hsqls":["SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay)  FROM 
mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
(DivTailNums__MV0 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV1 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV2 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV3 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV4 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951')) LIMIT 
10000"]}
-{"sql":"SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 
IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR DivAirportIDs IN 
(14730, 14262, 10868) LIMIT 6","hsqls":["SELECT MIN(DaysSinceEpoch), 
AVG(FlightNum)  FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID 
BETWEEN 20366 AND 19393 OR (DivAirportIDs__MV0 IN (14730, 14262, 10868) OR 
DivAirportIDs__MV1 IN (14730, 14262, 10868) OR DivAirportIDs__MV2 IN (14730, 
14262, 10868) OR DivAirportIDs__MV3 IN (14730, 14262, 10868) OR 
DivAirportIDs__MV4 IN (14730, 14262, 10868)) LIMIT 10000"]}
-{"sql":"SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE 
UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND DivWheelsOns IN (1717, 102, 1835) 
LIMIT 24","hsqls":["SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime)  FROM 
mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND (DivWheelsOns__MV0 
IN (1717, 102, 1835) OR DivWheelsOns__MV1 IN (1717, 102, 1835) OR 
DivWheelsOns__MV2 IN (1717, 102, 1835) OR DivWheelsOns__MV3 IN (1717, 102, 
1835) OR DivWheelsOns__MV4 IN (1717, 102, 1835)) LIMIT 10000"]}
+{"sql":"SELECT MAX(\"Year\") FROM mytable WHERE DivWheelsOns >= 2058 OR 
UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 
20","hsqls":["SELECT MAX(`Year`) FROM mytable WHERE (DivWheelsOns[1] >= 2058 OR 
DivWheelsOns[2] >= 2058 OR DivWheelsOns[3] >= 2058 OR DivWheelsOns[4] >= 2058 
OR DivWheelsOns[5] >= 2058) OR UniqueCarrier BETWEEN 'VX' AND 'US' OR 
CRSElapsedTime > 290 LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable 
WHERE DivWheelsOffs >= 2009 AND Diverted >= 1 OR OriginCityMarketID >= 34783 
LIMIT 29","hsqls":["SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek)  
FROM mytable WHERE (DivWheelsOffs[1] >= 2009 OR DivWheelsOffs[2] >= 2009 OR 
DivWheelsOffs[3] >= 2009 OR DivWheelsOffs[4] >= 2009 OR DivWheelsOffs[5] >= 
2009) AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable 
WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
DivTailNums IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') LIMIT 
29","hsqls":["SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay)  FROM 
mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
(DivTailNums[1] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[2] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[3] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[4] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[5] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951')) LIMIT 
10000"]}
+{"sql":"SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 
IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR DivAirportIDs IN 
(14730, 14262, 10868) LIMIT 6","hsqls":["SELECT MIN(DaysSinceEpoch), 
AVG(FlightNum)  FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID 
BETWEEN 20366 AND 19393 OR (DivAirportIDs[1] IN (14730, 14262, 10868) OR 
DivAirportIDs[2] IN (14730, 14262, 10868) OR DivAirportIDs[3] IN (14730, 14262, 
10868) OR DivAirportIDs[4] IN (14730, 14262, 10868) OR DivAirportIDs[5] IN 
(14730, 14262, 10868)) LIMIT 10000"]}
+{"sql":"SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE 
UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND DivWheelsOns IN (1717, 102, 1835) 
LIMIT 24","hsqls":["SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime)  FROM 
mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND (DivWheelsOns[1] IN 
(1717, 102, 1835) OR DivWheelsOns[2] IN (1717, 102, 1835) OR DivWheelsOns[3] IN 
(1717, 102, 1835) OR DivWheelsOns[4] IN (1717, 102, 1835) OR DivWheelsOns[5] IN 
(1717, 102, 1835)) LIMIT 10000"]}
 {"sql":"SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable WHERE 
DivReachedDest BETWEEN -9999 AND -9999 AND \"Year\" < 2014 OR CRSElapsedTime >= 
337 LIMIT 29","hsqls":["SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable 
WHERE DivReachedDest BETWEEN -9999 AND -9999 AND `Year` < 2014 OR 
CRSElapsedTime >= 337 LIMIT 29"]}
 {"sql":"SELECT MIN(FlightNum), MAX(CRSDepTime), COUNT(DestState) FROM mytable 
WHERE Flights BETWEEN 1 AND 1 OR \"Month\" <> 1 AND DivReachedDest BETWEEN 0 
AND 0 LIMIT 5","hsqls":["SELECT MIN(FlightNum), MAX(CRSDepTime), 
COUNT(DestState) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR `Month` <> 1 AND 
DivReachedDest BETWEEN 0 AND 0 LIMIT 5"]}
-{"sql":"SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT 
IN (4484) AND DivAirportSeqIDs >= 1323202 AND DayOfWeek NOT IN (2, 1) LIMIT 
14","hsqls":["SELECT MIN(Flights), SUM(CRSArrTime)  FROM mytable WHERE 
FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR 
DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR 
DivAirportSeqIDs__MV3 >= 1323202 OR DivAirportSeqIDs__MV4 >= 1323202) AND 
DayOfWeek NOT IN (2, 1) LIMIT 10000"]}
-{"sql":"SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE DivTailNums IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') LIMIT 7","hsqls":["SELECT 
SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE (DivTailNums__MV0 IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV1 IN ('N3751B', 
'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV2 IN ('N3751B', 'N296WN', 
'N416SW', 'N472WN') OR DivTailNums__MV3 IN ('N3751B', 'N296WN', 'N416SW', 
'N472WN') OR DivTailNums__MV4 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN')) 
LIMIT 10000"]}
-{"sql":"SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), 
AVG(DivActualElapsedTime) FROM mytable WHERE DivTotalGTimes > 18 AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 22","hsqls":["SELECT SUM(DivActualElapsedTime), 
COUNT(LateAircraftDelay), AVG(DivActualElapsedTime)  FROM mytable WHERE 
(DivTotalGTimes__MV0 > 18 OR DivTotalGTimes__MV1 > 18 OR DivTotalGTimes__MV2 > 
18 OR DivTotalGTimes__MV3 > 18 OR DivTotalGTimes__MV4 > 18) AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 10000"]}
-{"sql":"SELECT SUM(DivActualElapsedTime), MAX(\"Month\") FROM mytable WHERE 
Distance <> 788 AND DivWheelsOffs > 1851 LIMIT 5","hsqls":["SELECT 
SUM(DivActualElapsedTime), MAX(`Month`)  FROM mytable WHERE Distance <> 788 AND 
(DivWheelsOffs__MV0 > 1851 OR DivWheelsOffs__MV1 > 1851 OR DivWheelsOffs__MV2 > 
1851 OR DivWheelsOffs__MV3 > 1851 OR DivWheelsOffs__MV4 > 1851) LIMIT 10000"]}
-{"sql":"SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE 
DivTailNums IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') AND 
DestAirportID < 11867 OR Carrier NOT IN ('DL', 'WN') LIMIT 20","hsqls":["SELECT 
SUM(DivArrDelay), SUM(DestStateFips)  FROM mytable WHERE (DivTailNums__MV0 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV1 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV2 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV3 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV4 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA')) AND DestAirportID < 11867 OR 
Carrier NOT IN ('DL', 'WN') LIMIT 10000"]}
-{"sql":"SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE 
DivWheelsOns BETWEEN 728 AND 1804 LIMIT 13","hsqls":["SELECT 
SUM(DivReachedDest), AVG(DestWac)  FROM mytable WHERE (DivWheelsOns__MV0 
BETWEEN 728 AND 1804 OR DivWheelsOns__MV1 BETWEEN 728 AND 1804 OR 
DivWheelsOns__MV2 BETWEEN 728 AND 1804 OR DivWheelsOns__MV3 BETWEEN 728 AND 
1804 OR DivWheelsOns__MV4 BETWEEN 728 AND 1804) LIMIT 10000"]}
-{"sql":"SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable 
WHERE DivAirports IN ('RFD') AND TaxiIn BETWEEN -9999 AND 94 LIMIT 
29","hsqls":["SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState)  FROM 
mytable WHERE (DivAirports__MV0 IN ('RFD') OR DivAirports__MV1 IN ('RFD') OR 
DivAirports__MV2 IN ('RFD') OR DivAirports__MV3 IN ('RFD') OR DivAirports__MV4 
IN ('RFD')) AND TaxiIn BETWEEN -9999 AND 94 LIMIT 10000"]}
+{"sql":"SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT 
IN (4484) AND DivAirportSeqIDs >= 1323202 AND DayOfWeek NOT IN (2, 1) LIMIT 
14","hsqls":["SELECT MIN(Flights), SUM(CRSArrTime)  FROM mytable WHERE 
FlightNum NOT IN (4484) AND (DivAirportSeqIDs[1] >= 1323202 OR 
DivAirportSeqIDs[2] >= 1323202 OR DivAirportSeqIDs[3] >= 1323202 OR 
DivAirportSeqIDs[4] >= 1323202 OR DivAirportSeqIDs[5] >= 1323202) AND DayOfWeek 
NOT IN (2, 1) LIMIT 10000"]}
+{"sql":"SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE DivTailNums IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') LIMIT 7","hsqls":["SELECT 
SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE (DivTailNums[1] IN ('N3751B', 
'N296WN', 'N416SW', 'N472WN') OR DivTailNums[2] IN ('N3751B', 'N296WN', 
'N416SW', 'N472WN') OR DivTailNums[3] IN ('N3751B', 'N296WN', 'N416SW', 
'N472WN') OR DivTailNums[4] IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR 
DivTailNums[5] IN ('N3751B', 'N296WN', 'N416SW', 'N472WN')) LIMIT 10000"]}
+{"sql":"SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), 
AVG(DivActualElapsedTime) FROM mytable WHERE DivTotalGTimes > 18 AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 22","hsqls":["SELECT SUM(DivActualElapsedTime), 
COUNT(LateAircraftDelay), AVG(DivActualElapsedTime)  FROM mytable WHERE 
(DivTotalGTimes[1] > 18 OR DivTotalGTimes[2] > 18 OR DivTotalGTimes[3] > 18 OR 
DivTotalGTimes[4] > 18 OR DivTotalGTimes[5] > 18) AND OriginCityMarketID IN 
(30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 AND 1 LIMIT 10000"]}
+{"sql":"SELECT SUM(DivActualElapsedTime), MAX(\"Month\") FROM mytable WHERE 
Distance <> 788 AND DivWheelsOffs > 1851 LIMIT 5","hsqls":["SELECT 
SUM(DivActualElapsedTime), MAX(`Month`)  FROM mytable WHERE Distance <> 788 AND 
(DivWheelsOffs[1] > 1851 OR DivWheelsOffs[2] > 1851 OR DivWheelsOffs[3] > 1851 
OR DivWheelsOffs[4] > 1851 OR DivWheelsOffs[5] > 1851) LIMIT 10000"]}
+{"sql":"SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE 
DivTailNums IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') AND 
DestAirportID < 11867 OR Carrier NOT IN ('DL', 'WN') LIMIT 20","hsqls":["SELECT 
SUM(DivArrDelay), SUM(DestStateFips)  FROM mytable WHERE (DivTailNums[1] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[2] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[3] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[4] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[5] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA')) AND DestAirportID < 11867 OR 
Carrier NOT IN ('DL', 'WN') LIMIT 10000"]}
+{"sql":"SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE 
DivWheelsOns BETWEEN 728 AND 1804 LIMIT 13","hsqls":["SELECT 
SUM(DivReachedDest), AVG(DestWac)  FROM mytable WHERE (DivWheelsOns[1] BETWEEN 
728 AND 1804 OR DivWheelsOns[2] BETWEEN 728 AND 1804 OR DivWheelsOns[3] BETWEEN 
728 AND 1804 OR DivWheelsOns[4] BETWEEN 728 AND 1804 OR DivWheelsOns[5] BETWEEN 
728 AND 1804) LIMIT 10000"]}
+{"sql":"SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable 
WHERE DivAirports IN ('RFD') AND TaxiIn BETWEEN -9999 AND 94 LIMIT 
29","hsqls":["SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState)  FROM 
mytable WHERE (DivAirports[1] IN ('RFD') OR DivAirports[2] IN ('RFD') OR 
DivAirports[3] IN ('RFD') OR DivAirports[4] IN ('RFD') OR DivAirports[5] IN 
('RFD')) AND TaxiIn BETWEEN -9999 AND 94 LIMIT 10000"]}
 {"sql":"SELECT SUM(\"Month\") FROM mytable WHERE FirstDepTime <> 1742 AND 
DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 
23","hsqls":["SELECT SUM(`Month`) FROM mytable WHERE FirstDepTime <> 1742 AND 
DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 23"]}
-{"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 
10","hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM 
mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes__MV0 IN (30, 113, 102, 37) 
OR DivTotalGTimes__MV1 IN (30, 113, 102, 37) OR DivTotalGTimes__MV2 IN (30, 
113, 102, 37) OR DivTotalGTimes__MV3 IN (30, 113, 102, 37) OR 
DivTotalGTimes__MV4 IN (30, 113, 102, 37)) LIMIT 10000"]}
+{"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 
10","hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM 
mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes[1] IN (30, 113, 102, 37) OR 
DivTotalGTimes[2] IN (30, 113, 102, 37) OR DivTotalGTimes[3] IN (30, 113, 102, 
37) OR DivTotalGTimes[4] IN (30, 113, 102, 37) OR DivTotalGTimes[5] IN (30, 
113, 102, 37)) LIMIT 10000"]}

Review Comment:
   I dig a bit one thing is to change the query to use `ARRAY_CONTAINS`, e.g.
   ```
   {"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 
10","hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM 
mytable WHERE (WheelsOff > 1737) AND (ARRAY_CONTAINS(DivTotalGTimes, 30) OR 
ARRAY_CONTAINS(DivTotalGTimes, 37) OR ARRAY_CONTAINS(DivTotalGTimes, 102) OR 
ARRAY_CONTAINS(DivTotalGTimes, 113)) LIMIT 10000"]}
   ```



##########
pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_200.sql:
##########
@@ -117,54 +117,54 @@
 {"sql":"SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable GROUP BY 
WheelsOn, OriginStateName  ORDER BY WheelsOn, OriginStateName LIMIT 
18","hsqls":["SELECT WheelsOn, OriginStateName, AVG(DepDel15) FROM mytable 
GROUP BY WheelsOn, OriginStateName  ORDER BY WheelsOn, OriginStateName LIMIT 
18"]}
 
 # Filtering on Aggregation
-{"sql":"SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE 
DivTailNums BETWEEN 'N8315C' AND 'N130DL' OR DivAirports IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT') AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 
5","hsqls":["SELECT AVG(AirTime), SUM(OriginStateFips)  FROM mytable WHERE 
(DivTailNums__MV0 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV1 BETWEEN 
'N8315C' AND 'N130DL' OR DivTailNums__MV2 BETWEEN 'N8315C' AND 'N130DL' OR 
DivTailNums__MV3 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV4 BETWEEN 
'N8315C' AND 'N130DL') OR (DivAirports__MV0 IN ('PIH', 'DLH', 'MTJ', 'SEA', 
'LIT') OR DivAirports__MV1 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR 
DivAirports__MV2 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV3 IN 
('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV4 IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT')) AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 10000"]}
-{"sql":"SELECT AVG(ArrDel15) FROM mytable WHERE DivWheelsOffs >= 1610 LIMIT 
13","hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable WHERE 
(DivWheelsOffs__MV0 >= 1610 OR DivWheelsOffs__MV1 >= 1610 OR DivWheelsOffs__MV2 
>= 1610 OR DivWheelsOffs__MV3 >= 1610 OR DivWheelsOffs__MV4 >= 1610) LIMIT 
10000"]}
+{"sql":"SELECT AVG(AirTime), SUM(OriginStateFips) FROM mytable WHERE 
DivTailNums BETWEEN 'N8315C' AND 'N130DL' OR DivAirports IN ('PIH', 'DLH', 
'MTJ', 'SEA', 'LIT') AND TaxiOut NOT IN (59, 112, 57, 72) LIMIT 
5","hsqls":["SELECT AVG(AirTime), SUM(OriginStateFips)  FROM mytable WHERE 
(DivTailNums[1] BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums[2] BETWEEN 
'N8315C' AND 'N130DL' OR DivTailNums[3] BETWEEN 'N8315C' AND 'N130DL' OR 
DivTailNums[4] BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums[5] BETWEEN 'N8315C' 
AND 'N130DL') OR (DivAirports[1] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR 
DivAirports[2] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports[3] IN 
('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports[4] IN ('PIH', 'DLH', 'MTJ', 
'SEA', 'LIT') OR DivAirports[5] IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT')) AND 
TaxiOut NOT IN (59, 112, 57, 72) LIMIT 10000"]}
+{"sql":"SELECT AVG(ArrDel15) FROM mytable WHERE DivWheelsOffs >= 1610 LIMIT 
13","hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable WHERE 
(DivWheelsOffs[1] >= 1610 OR DivWheelsOffs[2] >= 1610 OR DivWheelsOffs[3] >= 
1610 OR DivWheelsOffs[4] >= 1610 OR DivWheelsOffs[5] >= 1610) LIMIT 10000"]}
 {"sql":"SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE 
\"Year\" = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 
22","hsqls":["SELECT AVG(CRSDepTime), MIN(DivReachedDest) FROM mytable WHERE 
`Year` = 2014 OR Origin BETWEEN 'MLU' AND 'BDL' OR DestStateFips > 18 LIMIT 
22"]}
 {"sql":"SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) FROM 
mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 
14","hsqls":["SELECT AVG(CarrierDelay), AVG(OriginCityMarketID), MAX(ArrTime) 
FROM mytable WHERE `Year` BETWEEN 2014 AND 2014 OR AirlineID <= 20398 LIMIT 
14"]}
-{"sql":"SELECT AVG(DayOfWeek) FROM mytable WHERE DivTailNums IN ('N915DE', 
'N8612K') LIMIT 3","hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable 
WHERE (DivTailNums__MV0 IN ('N915DE', 'N8612K') OR DivTailNums__MV1 IN 
('N915DE', 'N8612K') OR DivTailNums__MV2 IN ('N915DE', 'N8612K') OR 
DivTailNums__MV3 IN ('N915DE', 'N8612K') OR DivTailNums__MV4 IN ('N915DE', 
'N8612K')) LIMIT 10000"]}
-{"sql":"SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE 
DivAirportSeqIDs >= 1281902 OR DestAirportSeqID NOT IN (1463502, 1530402, 
1068502) AND DepDelayMinutes BETWEEN 48.0 AND 94.0 LIMIT 18","hsqls":["SELECT 
AVG(DayOfWeek), MAX(Diverted)  FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 
1281902 OR DivAirportSeqIDs__MV1 >= 1281902 OR DivAirportSeqIDs__MV2 >= 1281902 
OR DivAirportSeqIDs__MV3 >= 1281902 OR DivAirportSeqIDs__MV4 >= 1281902) OR 
DestAirportSeqID NOT IN (1463502, 1530402, 1068502) AND DepDelayMinutes BETWEEN 
48.0 AND 94.0 LIMIT 10000"]}
+{"sql":"SELECT AVG(DayOfWeek) FROM mytable WHERE DivTailNums IN ('N915DE', 
'N8612K') LIMIT 3","hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable 
WHERE (DivTailNums[1] IN ('N915DE', 'N8612K') OR DivTailNums[2] IN ('N915DE', 
'N8612K') OR DivTailNums[3] IN ('N915DE', 'N8612K') OR DivTailNums[4] IN 
('N915DE', 'N8612K') OR DivTailNums[5] IN ('N915DE', 'N8612K')) LIMIT 10000"]}
+{"sql":"SELECT AVG(DayOfWeek), MAX(Diverted) FROM mytable WHERE 
DivAirportSeqIDs >= 1281902 OR DestAirportSeqID NOT IN (1463502, 1530402, 
1068502) AND DepDelayMinutes BETWEEN 48.0 AND 94.0 LIMIT 18","hsqls":["SELECT 
AVG(DayOfWeek), MAX(Diverted)  FROM mytable WHERE (DivAirportSeqIDs[1] >= 
1281902 OR DivAirportSeqIDs[2] >= 1281902 OR DivAirportSeqIDs[3] >= 1281902 OR 
DivAirportSeqIDs[4] >= 1281902 OR DivAirportSeqIDs[5] >= 1281902) OR 
DestAirportSeqID NOT IN (1463502, 1530402, 1068502) AND DepDelayMinutes BETWEEN 
48.0 AND 94.0 LIMIT 10000"]}
 {"sql":"SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE 
LateAircraftDelay BETWEEN 151 AND 72 OR \"Year\" IN (2014) LIMIT 
14","hsqls":["SELECT AVG(DayofMonth), COUNT(CRSElapsedTime) FROM mytable WHERE 
LateAircraftDelay BETWEEN 151 AND 72 OR `Year` IN (2014) LIMIT 14"]}
-{"sql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DivAirportIDs > 14027 
AND DivLongestGTimes >= 61.0 AND Cancelled BETWEEN 0 AND 1 LIMIT 
3","hsqls":["SELECT AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE 
(DivAirportIDs__MV0 > 14027 OR DivAirportIDs__MV1 > 14027 OR DivAirportIDs__MV2 
> 14027 OR DivAirportIDs__MV3 > 14027 OR DivAirportIDs__MV4 > 14027) AND 
(DivLongestGTimes__MV0 >= 61.0 OR DivLongestGTimes__MV1 >= 61.0 OR 
DivLongestGTimes__MV2 >= 61.0 OR DivLongestGTimes__MV3 >= 61.0 OR 
DivLongestGTimes__MV4 >= 61.0) AND Cancelled BETWEEN 0 AND 1 LIMIT 10000"]}
+{"sql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DivAirportIDs > 14027 
AND DivLongestGTimes >= 61.0 AND Cancelled BETWEEN 0 AND 1 LIMIT 
3","hsqls":["SELECT AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE 
(DivAirportIDs[1] > 14027 OR DivAirportIDs[2] > 14027 OR DivAirportIDs[3] > 
14027 OR DivAirportIDs[4] > 14027 OR DivAirportIDs[5] > 14027) AND 
(DivLongestGTimes[1] >= 61.0 OR DivLongestGTimes[2] >= 61.0 OR 
DivLongestGTimes[3] >= 61.0 OR DivLongestGTimes[4] >= 61.0 OR 
DivLongestGTimes[5] >= 61.0) AND Cancelled BETWEEN 0 AND 1 LIMIT 10000"]}
 {"sql":"SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM mytable WHERE 
\"Year\" NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND DayOfWeek NOT IN 
(6, 5) LIMIT 15","hsqls":["SELECT AVG(TotalAddGTime), MAX(OriginStateFips) FROM 
mytable WHERE `Year` NOT IN (2014) OR ArrDelay BETWEEN -30.0 AND 31.0 AND 
DayOfWeek NOT IN (6, 5) LIMIT 15"]}
-{"sql":"SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) 
FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR DivWheelsOffs 
BETWEEN 1719 AND 1720 LIMIT 16","hsqls":["SELECT AVG(TotalAddGTime), 
SUM(ArrivalDelayGroups), SUM(SecurityDelay)  FROM mytable WHERE UniqueCarrier = 
'AA' OR Cancelled IN (1, 0) OR (DivWheelsOffs__MV0 BETWEEN 1719 AND 1720 OR 
DivWheelsOffs__MV1 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV2 BETWEEN 1719 AND 
1720 OR DivWheelsOffs__MV3 BETWEEN 1719 AND 1720 OR DivWheelsOffs__MV4 BETWEEN 
1719 AND 1720) LIMIT 10000"]}
-{"sql":"SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 
OR DivAirports >= 'SIT' OR OriginWac BETWEEN 1 AND 71 LIMIT 
21","hsqls":["SELECT AVG(WeatherDelay), MIN(ArrTime)  FROM mytable WHERE TaxiIn 
< 162 OR (DivAirports__MV0 >= 'SIT' OR DivAirports__MV1 >= 'SIT' OR 
DivAirports__MV2 >= 'SIT' OR DivAirports__MV3 >= 'SIT' OR DivAirports__MV4 >= 
'SIT') OR OriginWac BETWEEN 1 AND 71 LIMIT 10000"]}
-{"sql":"SELECT AVG(\"Year\"), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1702, 2226, 749, 
2328, 844) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 
2","hsqls":["SELECT AVG(`Year`), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups)  FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 
2226, 749, 2328, 844) OR DivWheelsOffs__MV1 IN (1702, 2226, 749, 2328, 844) OR 
DivWheelsOffs__MV2 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV3 IN 
(1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV4 IN (1702, 2226, 749, 2328, 
844)) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000"]}
-{"sql":"SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 
247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND DivAirportSeqIDs BETWEEN 
1252302 AND 1232303 LIMIT 4","hsqls":["SELECT COUNT(*) FROM mytable WHERE 
ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 
AND 4 AND (DivAirportSeqIDs__MV0 BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs__MV1 BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV2 
BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs__MV3 BETWEEN 1252302 AND 
1232303 OR DivAirportSeqIDs__MV4 BETWEEN 1252302 AND 1232303) LIMIT 10000"]}
-{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR DivTailNums > 
'N854AS' AND DayOfWeek NOT IN (3, 1, 6) LIMIT 15","hsqls":["SELECT COUNT(*) 
FROM mytable WHERE CRSArrTime <> 1940 OR (DivTailNums__MV0 > 'N854AS' OR 
DivTailNums__MV1 > 'N854AS' OR DivTailNums__MV2 > 'N854AS' OR DivTailNums__MV3 
> 'N854AS' OR DivTailNums__MV4 > 'N854AS') AND DayOfWeek NOT IN (3, 1, 6) LIMIT 
10000"]}
+{"sql":"SELECT AVG(TotalAddGTime), SUM(ArrivalDelayGroups), SUM(SecurityDelay) 
FROM mytable WHERE UniqueCarrier = 'AA' OR Cancelled IN (1, 0) OR DivWheelsOffs 
BETWEEN 1719 AND 1720 LIMIT 16","hsqls":["SELECT AVG(TotalAddGTime), 
SUM(ArrivalDelayGroups), SUM(SecurityDelay)  FROM mytable WHERE UniqueCarrier = 
'AA' OR Cancelled IN (1, 0) OR (DivWheelsOffs[1] BETWEEN 1719 AND 1720 OR 
DivWheelsOffs[2] BETWEEN 1719 AND 1720 OR DivWheelsOffs[3] BETWEEN 1719 AND 
1720 OR DivWheelsOffs[4] BETWEEN 1719 AND 1720 OR DivWheelsOffs[5] BETWEEN 1719 
AND 1720) LIMIT 10000"]}
+{"sql":"SELECT AVG(WeatherDelay), MIN(ArrTime) FROM mytable WHERE TaxiIn < 162 
OR DivAirports >= 'SIT' OR OriginWac BETWEEN 1 AND 71 LIMIT 
21","hsqls":["SELECT AVG(WeatherDelay), MIN(ArrTime)  FROM mytable WHERE TaxiIn 
< 162 OR (DivAirports[1] >= 'SIT' OR DivAirports[2] >= 'SIT' OR DivAirports[3] 
>= 'SIT' OR DivAirports[4] >= 'SIT' OR DivAirports[5] >= 'SIT') OR OriginWac 
BETWEEN 1 AND 71 LIMIT 10000"]}
+{"sql":"SELECT AVG(\"Year\"), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1702, 2226, 749, 
2328, 844) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 
2","hsqls":["SELECT AVG(`Year`), SUM(ArrivalDelayGroups), 
MAX(DepartureDelayGroups)  FROM mytable WHERE (DivWheelsOffs[1] IN (1702, 2226, 
749, 2328, 844) OR DivWheelsOffs[2] IN (1702, 2226, 749, 2328, 844) OR 
DivWheelsOffs[3] IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs[4] IN (1702, 
2226, 749, 2328, 844) OR DivWheelsOffs[5] IN (1702, 2226, 749, 2328, 844)) OR 
ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE ActualElapsedTime NOT IN (90, 178, 
247, 118, 119) OR DistanceGroup BETWEEN 10 AND 4 AND DivAirportSeqIDs BETWEEN 
1252302 AND 1232303 LIMIT 4","hsqls":["SELECT COUNT(*) FROM mytable WHERE 
ActualElapsedTime NOT IN (90, 178, 247, 118, 119) OR DistanceGroup BETWEEN 10 
AND 4 AND (DivAirportSeqIDs[1] BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs[2] BETWEEN 1252302 AND 1232303 OR DivAirportSeqIDs[3] BETWEEN 
1252302 AND 1232303 OR DivAirportSeqIDs[4] BETWEEN 1252302 AND 1232303 OR 
DivAirportSeqIDs[5] BETWEEN 1252302 AND 1232303) LIMIT 10000"]}
+{"sql":"SELECT COUNT(*) FROM mytable WHERE CRSArrTime <> 1940 OR DivTailNums > 
'N854AS' AND DayOfWeek NOT IN (3, 1, 6) LIMIT 15","hsqls":["SELECT COUNT(*) 
FROM mytable WHERE CRSArrTime <> 1940 OR (DivTailNums[1] > 'N854AS' OR 
DivTailNums[2] > 'N854AS' OR DivTailNums[3] > 'N854AS' OR DivTailNums[4] > 
'N854AS' OR DivTailNums[5] > 'N854AS') AND DayOfWeek NOT IN (3, 1, 6) LIMIT 
10000"]}
 {"sql":"SELECT COUNT(*) FROM mytable WHERE \"Year\" BETWEEN 2014 AND 2014 OR 
DepTimeBlk BETWEEN '1400-1459' AND '1300-1359' LIMIT 8","hsqls":["SELECT 
COUNT(*) FROM mytable WHERE `Year` BETWEEN 2014 AND 2014 OR DepTimeBlk BETWEEN 
'1400-1459' AND '1300-1359' LIMIT 8"]}
-{"sql":"SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR DivTotalGTimes IN (62) LIMIT 
18","hsqls":["SELECT COUNT(ActualElapsedTime), AVG(DestWac)  FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR (DivTotalGTimes__MV0 IN (62) OR 
DivTotalGTimes__MV1 IN (62) OR DivTotalGTimes__MV2 IN (62) OR 
DivTotalGTimes__MV3 IN (62) OR DivTotalGTimes__MV4 IN (62)) LIMIT 10000"]}
-{"sql":"SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR 
DivWheelsOffs BETWEEN 2043 AND 2133 AND FlightNum NOT IN (3228) LIMIT 
11","hsqls":["SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 
0 OR (DivWheelsOffs__MV0 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV1 BETWEEN 
2043 AND 2133 OR DivWheelsOffs__MV2 BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV3 
BETWEEN 2043 AND 2133 OR DivWheelsOffs__MV4 BETWEEN 2043 AND 2133) AND 
FlightNum NOT IN (3228) LIMIT 10000"]}
-{"sql":"SELECT COUNT(CRSElapsedTime) FROM mytable WHERE DivWheelsOffs BETWEEN 
1257 AND 325 AND DestState IN ('LA', 'MS') AND \"Month\" BETWEEN 1 AND 1 LIMIT 
6","hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable WHERE 
(DivWheelsOffs__MV0 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV1 BETWEEN 1257 AND 
325 OR DivWheelsOffs__MV2 BETWEEN 1257 AND 325 OR DivWheelsOffs__MV3 BETWEEN 
1257 AND 325 OR DivWheelsOffs__MV4 BETWEEN 1257 AND 325) AND DestState IN 
('LA', 'MS') AND `Month` BETWEEN 1 AND 1 LIMIT 10000"]}
-{"sql":"SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) 
FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 
OR DivTotalGTimes BETWEEN 57 AND 76","hsqls":["SELECT COUNT(Carrier), 
MIN(DivActualElapsedTime), MAX(DepDelayMinutes)  FROM mytable WHERE 
DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR 
(DivTotalGTimes__MV0 BETWEEN 57 AND 76 OR DivTotalGTimes__MV1 BETWEEN 57 AND 76 
OR DivTotalGTimes__MV2 BETWEEN 57 AND 76 OR DivTotalGTimes__MV3 BETWEEN 57 AND 
76 OR DivTotalGTimes__MV4 BETWEEN 57 AND 76) LIMIT 10000"]}
-{"sql":"SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE 
DaysSinceEpoch <= 16073 AND DivAirportIDs IN (12278, 12451, 11973, 13424) LIMIT 
15","hsqls":["SELECT COUNT(CarrierDelay), SUM(DestAirportID)  FROM mytable 
WHERE DaysSinceEpoch <= 16073 AND (DivAirportIDs__MV0 IN (12278, 12451, 11973, 
13424) OR DivAirportIDs__MV1 IN (12278, 12451, 11973, 13424) OR 
DivAirportIDs__MV2 IN (12278, 12451, 11973, 13424) OR DivAirportIDs__MV3 IN 
(12278, 12451, 11973, 13424) OR DivAirportIDs__MV4 IN (12278, 12451, 11973, 
13424)) LIMIT 10000"]}
-{"sql":"SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) 
FROM mytable WHERE DivAirportSeqIDs < 1234302 LIMIT 26","hsqls":["SELECT 
COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups)  FROM mytable 
WHERE (DivAirportSeqIDs__MV0 < 1234302 OR DivAirportSeqIDs__MV1 < 1234302 OR 
DivAirportSeqIDs__MV2 < 1234302 OR DivAirportSeqIDs__MV3 < 1234302 OR 
DivAirportSeqIDs__MV4 < 1234302) LIMIT 10000"]}
-{"sql":"SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable 
WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND DivAirportIDs <= 
14006 LIMIT 22","hsqls":["SELECT COUNT(OriginCityMarketID), 
MAX(DestCityMarketID)  FROM mytable WHERE Quarter NOT IN (1) OR Distance 
BETWEEN 1454 AND 196 AND (DivAirportIDs__MV0 <= 14006 OR DivAirportIDs__MV1 <= 
14006 OR DivAirportIDs__MV2 <= 14006 OR DivAirportIDs__MV3 <= 14006 OR 
DivAirportIDs__MV4 <= 14006) LIMIT 10000"]}
-{"sql":"SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 
'A' AND 'A' AND DivTailNums BETWEEN 'N397DA' AND 'N940DN' LIMIT 
5","hsqls":["SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode 
BETWEEN 'A' AND 'A' AND (DivTailNums__MV0 BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums__MV1 BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums__MV2 BETWEEN 
'N397DA' AND 'N940DN' OR DivTailNums__MV3 BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums__MV4 BETWEEN 'N397DA' AND 'N940DN') LIMIT 10000"]}
-{"sql":"SELECT COUNT(\"Month\"), SUM(OriginAirportSeqID), MIN(AirlineID) FROM 
mytable WHERE DivTailNums <= 'N530MQ' AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 2","hsqls":["SELECT 
COUNT(`Month`), SUM(OriginAirportSeqID), MIN(AirlineID)  FROM mytable WHERE 
(DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR 
DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' OR 
DivTailNums__MV4 <= 'N530MQ') AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 10000"]}
-{"sql":"SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
DivTailNums IN ('N713SK') AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 
10","hsqls":["SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
(DivTailNums__MV0 IN ('N713SK') OR DivTailNums__MV1 IN ('N713SK') OR 
DivTailNums__MV2 IN ('N713SK') OR DivTailNums__MV3 IN ('N713SK') OR 
DivTailNums__MV4 IN ('N713SK')) AND DivActualElapsedTime BETWEEN 153 AND 1043 
LIMIT 10000"]}
+{"sql":"SELECT COUNT(ActualElapsedTime), AVG(DestWac) FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR DivTotalGTimes IN (62) LIMIT 
18","hsqls":["SELECT COUNT(ActualElapsedTime), AVG(DestWac)  FROM mytable WHERE 
DayOfWeek NOT IN (3, 1, 6, 4) OR (DivTotalGTimes[1] IN (62) OR 
DivTotalGTimes[2] IN (62) OR DivTotalGTimes[3] IN (62) OR DivTotalGTimes[4] IN 
(62) OR DivTotalGTimes[5] IN (62)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 0 OR 
DivWheelsOffs BETWEEN 2043 AND 2133 AND FlightNum NOT IN (3228) LIMIT 
11","hsqls":["SELECT COUNT(AirTime) FROM mytable WHERE Cancelled BETWEEN 0 AND 
0 OR (DivWheelsOffs[1] BETWEEN 2043 AND 2133 OR DivWheelsOffs[2] BETWEEN 2043 
AND 2133 OR DivWheelsOffs[3] BETWEEN 2043 AND 2133 OR DivWheelsOffs[4] BETWEEN 
2043 AND 2133 OR DivWheelsOffs[5] BETWEEN 2043 AND 2133) AND FlightNum NOT IN 
(3228) LIMIT 10000"]}
+{"sql":"SELECT COUNT(CRSElapsedTime) FROM mytable WHERE DivWheelsOffs BETWEEN 
1257 AND 325 AND DestState IN ('LA', 'MS') AND \"Month\" BETWEEN 1 AND 1 LIMIT 
6","hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable WHERE (DivWheelsOffs[1] 
BETWEEN 1257 AND 325 OR DivWheelsOffs[2] BETWEEN 1257 AND 325 OR 
DivWheelsOffs[3] BETWEEN 1257 AND 325 OR DivWheelsOffs[4] BETWEEN 1257 AND 325 
OR DivWheelsOffs[5] BETWEEN 1257 AND 325) AND DestState IN ('LA', 'MS') AND 
`Month` BETWEEN 1 AND 1 LIMIT 10000"]}
+{"sql":"SELECT COUNT(Carrier), MIN(DivActualElapsedTime), MAX(DepDelayMinutes) 
FROM mytable WHERE DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 
OR DivTotalGTimes BETWEEN 57 AND 76","hsqls":["SELECT COUNT(Carrier), 
MIN(DivActualElapsedTime), MAX(DepDelayMinutes)  FROM mytable WHERE 
DestCityMarketID NOT IN (31423) OR TaxiOut BETWEEN 24 AND 60 OR 
(DivTotalGTimes[1] BETWEEN 57 AND 76 OR DivTotalGTimes[2] BETWEEN 57 AND 76 OR 
DivTotalGTimes[3] BETWEEN 57 AND 76 OR DivTotalGTimes[4] BETWEEN 57 AND 76 OR 
DivTotalGTimes[5] BETWEEN 57 AND 76) LIMIT 10000"]}
+{"sql":"SELECT COUNT(CarrierDelay), SUM(DestAirportID) FROM mytable WHERE 
DaysSinceEpoch <= 16073 AND DivAirportIDs IN (12278, 12451, 11973, 13424) LIMIT 
15","hsqls":["SELECT COUNT(CarrierDelay), SUM(DestAirportID)  FROM mytable 
WHERE DaysSinceEpoch <= 16073 AND (DivAirportIDs[1] IN (12278, 12451, 11973, 
13424) OR DivAirportIDs[2] IN (12278, 12451, 11973, 13424) OR DivAirportIDs[3] 
IN (12278, 12451, 11973, 13424) OR DivAirportIDs[4] IN (12278, 12451, 11973, 
13424) OR DivAirportIDs[5] IN (12278, 12451, 11973, 13424)) LIMIT 10000"]}
+{"sql":"SELECT COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups) 
FROM mytable WHERE DivAirportSeqIDs < 1234302 LIMIT 26","hsqls":["SELECT 
COUNT(DestStateName), SUM(ArrDelay), SUM(DepartureDelayGroups)  FROM mytable 
WHERE (DivAirportSeqIDs[1] < 1234302 OR DivAirportSeqIDs[2] < 1234302 OR 
DivAirportSeqIDs[3] < 1234302 OR DivAirportSeqIDs[4] < 1234302 OR 
DivAirportSeqIDs[5] < 1234302) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginCityMarketID), MAX(DestCityMarketID) FROM mytable 
WHERE Quarter NOT IN (1) OR Distance BETWEEN 1454 AND 196 AND DivAirportIDs <= 
14006 LIMIT 22","hsqls":["SELECT COUNT(OriginCityMarketID), 
MAX(DestCityMarketID)  FROM mytable WHERE Quarter NOT IN (1) OR Distance 
BETWEEN 1454 AND 196 AND (DivAirportIDs[1] <= 14006 OR DivAirportIDs[2] <= 
14006 OR DivAirportIDs[3] <= 14006 OR DivAirportIDs[4] <= 14006 OR 
DivAirportIDs[5] <= 14006) LIMIT 10000"]}
+{"sql":"SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode BETWEEN 
'A' AND 'A' AND DivTailNums BETWEEN 'N397DA' AND 'N940DN' LIMIT 
5","hsqls":["SELECT COUNT(OriginWac) FROM mytable WHERE CancellationCode 
BETWEEN 'A' AND 'A' AND (DivTailNums[1] BETWEEN 'N397DA' AND 'N940DN' OR 
DivTailNums[2] BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums[3] BETWEEN 'N397DA' 
AND 'N940DN' OR DivTailNums[4] BETWEEN 'N397DA' AND 'N940DN' OR DivTailNums[5] 
BETWEEN 'N397DA' AND 'N940DN') LIMIT 10000"]}
+{"sql":"SELECT COUNT(\"Month\"), SUM(OriginAirportSeqID), MIN(AirlineID) FROM 
mytable WHERE DivTailNums <= 'N530MQ' AND AirTime NOT IN (122, 158, 73, 142) OR 
DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 2","hsqls":["SELECT 
COUNT(`Month`), SUM(OriginAirportSeqID), MIN(AirlineID)  FROM mytable WHERE 
(DivTailNums[1] <= 'N530MQ' OR DivTailNums[2] <= 'N530MQ' OR DivTailNums[3] <= 
'N530MQ' OR DivTailNums[4] <= 'N530MQ' OR DivTailNums[5] <= 'N530MQ') AND 
AirTime NOT IN (122, 158, 73, 142) OR DestAirportID NOT IN (10423, 13303, 
10581, 10747) LIMIT 10000"]}
+{"sql":"SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
DivTailNums IN ('N713SK') AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 
10","hsqls":["SELECT MAX(AirTime) FROM mytable WHERE DaysSinceEpoch <> 16071 OR 
(DivTailNums[1] IN ('N713SK') OR DivTailNums[2] IN ('N713SK') OR DivTailNums[3] 
IN ('N713SK') OR DivTailNums[4] IN ('N713SK') OR DivTailNums[5] IN ('N713SK')) 
AND DivActualElapsedTime BETWEEN 153 AND 1043 LIMIT 10000"]}
 {"sql":"SELECT MAX(ArrDelay), AVG(\"Month\"), MAX(ActualElapsedTime) FROM 
mytable WHERE DepTimeBlk IN ('2000-2059', '1300-1359', '1100-1159', 
'0600-0659', '0800-0859') LIMIT 14","hsqls":["SELECT MAX(ArrDelay), 
AVG(`Month`), MAX(ActualElapsedTime) FROM mytable WHERE DepTimeBlk IN 
('2000-2059', '1300-1359', '1100-1159', '0600-0659', '0800-0859') LIMIT 14"]}
-{"sql":"SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM 
mytable WHERE NASDelay IN (49, 145, 45) AND DivWheelsOffs < 917 AND 
UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 27","hsqls":["SELECT 
MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac)  FROM mytable WHERE 
NASDelay IN (49, 145, 45) AND (DivWheelsOffs__MV0 < 917 OR DivWheelsOffs__MV1 < 
917 OR DivWheelsOffs__MV2 < 917 OR DivWheelsOffs__MV3 < 917 OR 
DivWheelsOffs__MV4 < 917) AND UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 
'VX') LIMIT 10000"]}
+{"sql":"SELECT MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac) FROM 
mytable WHERE NASDelay IN (49, 145, 45) AND DivWheelsOffs < 917 AND 
UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 27","hsqls":["SELECT 
MAX(DistanceGroup), AVG(SecurityDelay), SUM(DestWac)  FROM mytable WHERE 
NASDelay IN (49, 145, 45) AND (DivWheelsOffs[1] < 917 OR DivWheelsOffs[2] < 917 
OR DivWheelsOffs[3] < 917 OR DivWheelsOffs[4] < 917 OR DivWheelsOffs[5] < 917) 
AND UniqueCarrier NOT IN ('F9', 'WN', 'OO', 'MQ', 'VX') LIMIT 10000"]}
 {"sql":"SELECT MAX(DivActualElapsedTime), MIN(\"Month\"), AVG(WheelsOff) FROM 
mytable WHERE Diverted NOT IN (1, 0) OR Diverted BETWEEN 0 AND 1 AND 
DestCityMarketID = 31136 LIMIT 27","hsqls":["SELECT MAX(DivActualElapsedTime), 
MIN(`Month`), AVG(WheelsOff) FROM mytable WHERE Diverted NOT IN (1, 0) OR 
Diverted BETWEEN 0 AND 1 AND DestCityMarketID = 31136 LIMIT 27"]}
-{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN 
('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN 
(16071, 16088, 16074, 16078, 16091) OR DivWheelsOns = 1317 LIMIT 
11","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT 
IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch 
IN (16071, 16088, 16074, 16078, 16091) OR (DivWheelsOns__MV0 = 1317 OR 
DivWheelsOns__MV1 = 1317 OR DivWheelsOns__MV2 = 1317 OR DivWheelsOns__MV3 = 
1317 OR DivWheelsOns__MV4 = 1317) LIMIT 10000"]}
-{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 
936) OR DivTotalGTimes > 76 LIMIT 1","hsqls":["SELECT MAX(LongestAddGTime) FROM 
mytable WHERE WheelsOn NOT IN (1659, 936) OR (DivTotalGTimes__MV0 > 76 OR 
DivTotalGTimes__MV1 > 76 OR DivTotalGTimes__MV2 > 76 OR DivTotalGTimes__MV3 > 
76 OR DivTotalGTimes__MV4 > 76) LIMIT 10000"]}
-{"sql":"SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE 
ArrDel15 IN (1, 0, -9999) OR DivLongestGTimes < 57.0 OR DepDelay NOT IN (342.0, 
48.0) LIMIT 25","hsqls":["SELECT MAX(WheelsOff), COUNT(CancellationCode)  FROM 
mytable WHERE ArrDel15 IN (1, 0, -9999) OR (DivLongestGTimes__MV0 < 57.0 OR 
DivLongestGTimes__MV1 < 57.0 OR DivLongestGTimes__MV2 < 57.0 OR 
DivLongestGTimes__MV3 < 57.0 OR DivLongestGTimes__MV4 < 57.0) OR DepDelay NOT 
IN (342.0, 48.0) LIMIT 10000"]}
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT IN 
('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch IN 
(16071, 16088, 16074, 16078, 16091) OR DivWheelsOns = 1317 LIMIT 
11","hsqls":["SELECT MAX(LongestAddGTime) FROM mytable WHERE DestStateName NOT 
IN ('New Hampshire', 'Massachusetts', 'California', 'Nevada') OR DaysSinceEpoch 
IN (16071, 16088, 16074, 16078, 16091) OR (DivWheelsOns[1] = 1317 OR 
DivWheelsOns[2] = 1317 OR DivWheelsOns[3] = 1317 OR DivWheelsOns[4] = 1317 OR 
DivWheelsOns[5] = 1317) LIMIT 10000"]}
+{"sql":"SELECT MAX(LongestAddGTime) FROM mytable WHERE WheelsOn NOT IN (1659, 
936) OR DivTotalGTimes > 76 LIMIT 1","hsqls":["SELECT MAX(LongestAddGTime) FROM 
mytable WHERE WheelsOn NOT IN (1659, 936) OR (DivTotalGTimes[1] > 76 OR 
DivTotalGTimes[2] > 76 OR DivTotalGTimes[3] > 76 OR DivTotalGTimes[4] > 76 OR 
DivTotalGTimes[5] > 76) LIMIT 10000"]}
+{"sql":"SELECT MAX(WheelsOff), COUNT(CancellationCode) FROM mytable WHERE 
ArrDel15 IN (1, 0, -9999) OR DivLongestGTimes < 57.0 OR DepDelay NOT IN (342.0, 
48.0) LIMIT 25","hsqls":["SELECT MAX(WheelsOff), COUNT(CancellationCode)  FROM 
mytable WHERE ArrDel15 IN (1, 0, -9999) OR (DivLongestGTimes[1] < 57.0 OR 
DivLongestGTimes[2] < 57.0 OR DivLongestGTimes[3] < 57.0 OR DivLongestGTimes[4] 
< 57.0 OR DivLongestGTimes[5] < 57.0) OR DepDelay NOT IN (342.0, 48.0) LIMIT 
10000"]}
 {"sql":"SELECT MAX(\"Month\") FROM mytable WHERE CRSDepTime IN (1534, 2213) OR 
DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 LIMIT 
11","hsqls":["SELECT MAX(`Month`) FROM mytable WHERE CRSDepTime IN (1534, 2213) 
OR DestCityName BETWEEN 'Sacramento, CA' AND 'Nome, AK' OR ArrDelay > -7.0 
LIMIT 11"]}
-{"sql":"SELECT MAX(\"Year\") FROM mytable WHERE DivWheelsOns >= 2058 OR 
UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 
20","hsqls":["SELECT MAX(`Year`) FROM mytable WHERE (DivWheelsOns__MV0 >= 2058 
OR DivWheelsOns__MV1 >= 2058 OR DivWheelsOns__MV2 >= 2058 OR DivWheelsOns__MV3 
>= 2058 OR DivWheelsOns__MV4 >= 2058) OR UniqueCarrier BETWEEN 'VX' AND 'US' OR 
CRSElapsedTime > 290 LIMIT 10000"]}
-{"sql":"SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable 
WHERE DivWheelsOffs >= 2009 AND Diverted >= 1 OR OriginCityMarketID >= 34783 
LIMIT 29","hsqls":["SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek)  
FROM mytable WHERE (DivWheelsOffs__MV0 >= 2009 OR DivWheelsOffs__MV1 >= 2009 OR 
DivWheelsOffs__MV2 >= 2009 OR DivWheelsOffs__MV3 >= 2009 OR DivWheelsOffs__MV4 
>= 2009) AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 10000"]}
-{"sql":"SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable 
WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
DivTailNums IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') LIMIT 
29","hsqls":["SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay)  FROM 
mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
(DivTailNums__MV0 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV1 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV2 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV3 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums__MV4 IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951')) LIMIT 
10000"]}
-{"sql":"SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 
IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR DivAirportIDs IN 
(14730, 14262, 10868) LIMIT 6","hsqls":["SELECT MIN(DaysSinceEpoch), 
AVG(FlightNum)  FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID 
BETWEEN 20366 AND 19393 OR (DivAirportIDs__MV0 IN (14730, 14262, 10868) OR 
DivAirportIDs__MV1 IN (14730, 14262, 10868) OR DivAirportIDs__MV2 IN (14730, 
14262, 10868) OR DivAirportIDs__MV3 IN (14730, 14262, 10868) OR 
DivAirportIDs__MV4 IN (14730, 14262, 10868)) LIMIT 10000"]}
-{"sql":"SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE 
UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND DivWheelsOns IN (1717, 102, 1835) 
LIMIT 24","hsqls":["SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime)  FROM 
mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND (DivWheelsOns__MV0 
IN (1717, 102, 1835) OR DivWheelsOns__MV1 IN (1717, 102, 1835) OR 
DivWheelsOns__MV2 IN (1717, 102, 1835) OR DivWheelsOns__MV3 IN (1717, 102, 
1835) OR DivWheelsOns__MV4 IN (1717, 102, 1835)) LIMIT 10000"]}
+{"sql":"SELECT MAX(\"Year\") FROM mytable WHERE DivWheelsOns >= 2058 OR 
UniqueCarrier BETWEEN 'VX' AND 'US' OR CRSElapsedTime > 290 LIMIT 
20","hsqls":["SELECT MAX(`Year`) FROM mytable WHERE (DivWheelsOns[1] >= 2058 OR 
DivWheelsOns[2] >= 2058 OR DivWheelsOns[3] >= 2058 OR DivWheelsOns[4] >= 2058 
OR DivWheelsOns[5] >= 2058) OR UniqueCarrier BETWEEN 'VX' AND 'US' OR 
CRSElapsedTime > 290 LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek) FROM mytable 
WHERE DivWheelsOffs >= 2009 AND Diverted >= 1 OR OriginCityMarketID >= 34783 
LIMIT 29","hsqls":["SELECT MIN(ArrDelay), COUNT(CRSDepTime), SUM(DayOfWeek)  
FROM mytable WHERE (DivWheelsOffs[1] >= 2009 OR DivWheelsOffs[2] >= 2009 OR 
DivWheelsOffs[3] >= 2009 OR DivWheelsOffs[4] >= 2009 OR DivWheelsOffs[5] >= 
2009) AND Diverted >= 1 OR OriginCityMarketID >= 34783 LIMIT 10000"]}
+{"sql":"SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay) FROM mytable 
WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
DivTailNums IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') LIMIT 
29","hsqls":["SELECT MIN(ArrTime), AVG(AirlineID), COUNT(WeatherDelay)  FROM 
mytable WHERE OriginCityName NOT IN ('Columbus, GA', 'Raleigh/Durham, NC') OR 
(DivTailNums[1] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[2] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[3] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[4] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951') OR 
DivTailNums[5] IN ('N314US', 'N3751B', 'N925DL', 'N393HA', 'N16951')) LIMIT 
10000"]}
+{"sql":"SELECT MIN(DaysSinceEpoch), AVG(FlightNum) FROM mytable WHERE DepDel15 
IN (1, 0, -9999) AND AirlineID BETWEEN 20366 AND 19393 OR DivAirportIDs IN 
(14730, 14262, 10868) LIMIT 6","hsqls":["SELECT MIN(DaysSinceEpoch), 
AVG(FlightNum)  FROM mytable WHERE DepDel15 IN (1, 0, -9999) AND AirlineID 
BETWEEN 20366 AND 19393 OR (DivAirportIDs[1] IN (14730, 14262, 10868) OR 
DivAirportIDs[2] IN (14730, 14262, 10868) OR DivAirportIDs[3] IN (14730, 14262, 
10868) OR DivAirportIDs[4] IN (14730, 14262, 10868) OR DivAirportIDs[5] IN 
(14730, 14262, 10868)) LIMIT 10000"]}
+{"sql":"SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime) FROM mytable WHERE 
UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND DivWheelsOns IN (1717, 102, 1835) 
LIMIT 24","hsqls":["SELECT MIN(DaysSinceEpoch), COUNT(CRSElapsedTime)  FROM 
mytable WHERE UniqueCarrier IN ('EV', 'F9', 'MQ', 'UA') AND (DivWheelsOns[1] IN 
(1717, 102, 1835) OR DivWheelsOns[2] IN (1717, 102, 1835) OR DivWheelsOns[3] IN 
(1717, 102, 1835) OR DivWheelsOns[4] IN (1717, 102, 1835) OR DivWheelsOns[5] IN 
(1717, 102, 1835)) LIMIT 10000"]}
 {"sql":"SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable WHERE 
DivReachedDest BETWEEN -9999 AND -9999 AND \"Year\" < 2014 OR CRSElapsedTime >= 
337 LIMIT 29","hsqls":["SELECT MIN(DivReachedDest), AVG(AirTime) FROM mytable 
WHERE DivReachedDest BETWEEN -9999 AND -9999 AND `Year` < 2014 OR 
CRSElapsedTime >= 337 LIMIT 29"]}
 {"sql":"SELECT MIN(FlightNum), MAX(CRSDepTime), COUNT(DestState) FROM mytable 
WHERE Flights BETWEEN 1 AND 1 OR \"Month\" <> 1 AND DivReachedDest BETWEEN 0 
AND 0 LIMIT 5","hsqls":["SELECT MIN(FlightNum), MAX(CRSDepTime), 
COUNT(DestState) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR `Month` <> 1 AND 
DivReachedDest BETWEEN 0 AND 0 LIMIT 5"]}
-{"sql":"SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT 
IN (4484) AND DivAirportSeqIDs >= 1323202 AND DayOfWeek NOT IN (2, 1) LIMIT 
14","hsqls":["SELECT MIN(Flights), SUM(CRSArrTime)  FROM mytable WHERE 
FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR 
DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR 
DivAirportSeqIDs__MV3 >= 1323202 OR DivAirportSeqIDs__MV4 >= 1323202) AND 
DayOfWeek NOT IN (2, 1) LIMIT 10000"]}
-{"sql":"SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE DivTailNums IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') LIMIT 7","hsqls":["SELECT 
SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE (DivTailNums__MV0 IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV1 IN ('N3751B', 
'N296WN', 'N416SW', 'N472WN') OR DivTailNums__MV2 IN ('N3751B', 'N296WN', 
'N416SW', 'N472WN') OR DivTailNums__MV3 IN ('N3751B', 'N296WN', 'N416SW', 
'N472WN') OR DivTailNums__MV4 IN ('N3751B', 'N296WN', 'N416SW', 'N472WN')) 
LIMIT 10000"]}
-{"sql":"SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), 
AVG(DivActualElapsedTime) FROM mytable WHERE DivTotalGTimes > 18 AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 22","hsqls":["SELECT SUM(DivActualElapsedTime), 
COUNT(LateAircraftDelay), AVG(DivActualElapsedTime)  FROM mytable WHERE 
(DivTotalGTimes__MV0 > 18 OR DivTotalGTimes__MV1 > 18 OR DivTotalGTimes__MV2 > 
18 OR DivTotalGTimes__MV3 > 18 OR DivTotalGTimes__MV4 > 18) AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 10000"]}
-{"sql":"SELECT SUM(DivActualElapsedTime), MAX(\"Month\") FROM mytable WHERE 
Distance <> 788 AND DivWheelsOffs > 1851 LIMIT 5","hsqls":["SELECT 
SUM(DivActualElapsedTime), MAX(`Month`)  FROM mytable WHERE Distance <> 788 AND 
(DivWheelsOffs__MV0 > 1851 OR DivWheelsOffs__MV1 > 1851 OR DivWheelsOffs__MV2 > 
1851 OR DivWheelsOffs__MV3 > 1851 OR DivWheelsOffs__MV4 > 1851) LIMIT 10000"]}
-{"sql":"SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE 
DivTailNums IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') AND 
DestAirportID < 11867 OR Carrier NOT IN ('DL', 'WN') LIMIT 20","hsqls":["SELECT 
SUM(DivArrDelay), SUM(DestStateFips)  FROM mytable WHERE (DivTailNums__MV0 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV1 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV2 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV3 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums__MV4 IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA')) AND DestAirportID < 11867 OR 
Carrier NOT IN ('DL', 'WN') LIMIT 10000"]}
-{"sql":"SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE 
DivWheelsOns BETWEEN 728 AND 1804 LIMIT 13","hsqls":["SELECT 
SUM(DivReachedDest), AVG(DestWac)  FROM mytable WHERE (DivWheelsOns__MV0 
BETWEEN 728 AND 1804 OR DivWheelsOns__MV1 BETWEEN 728 AND 1804 OR 
DivWheelsOns__MV2 BETWEEN 728 AND 1804 OR DivWheelsOns__MV3 BETWEEN 728 AND 
1804 OR DivWheelsOns__MV4 BETWEEN 728 AND 1804) LIMIT 10000"]}
-{"sql":"SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable 
WHERE DivAirports IN ('RFD') AND TaxiIn BETWEEN -9999 AND 94 LIMIT 
29","hsqls":["SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState)  FROM 
mytable WHERE (DivAirports__MV0 IN ('RFD') OR DivAirports__MV1 IN ('RFD') OR 
DivAirports__MV2 IN ('RFD') OR DivAirports__MV3 IN ('RFD') OR DivAirports__MV4 
IN ('RFD')) AND TaxiIn BETWEEN -9999 AND 94 LIMIT 10000"]}
+{"sql":"SELECT MIN(Flights), SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT 
IN (4484) AND DivAirportSeqIDs >= 1323202 AND DayOfWeek NOT IN (2, 1) LIMIT 
14","hsqls":["SELECT MIN(Flights), SUM(CRSArrTime)  FROM mytable WHERE 
FlightNum NOT IN (4484) AND (DivAirportSeqIDs[1] >= 1323202 OR 
DivAirportSeqIDs[2] >= 1323202 OR DivAirportSeqIDs[3] >= 1323202 OR 
DivAirportSeqIDs[4] >= 1323202 OR DivAirportSeqIDs[5] >= 1323202) AND DayOfWeek 
NOT IN (2, 1) LIMIT 10000"]}
+{"sql":"SELECT SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE DivTailNums IN 
('N3751B', 'N296WN', 'N416SW', 'N472WN') LIMIT 7","hsqls":["SELECT 
SUM(DepDel15), COUNT(AirTime) FROM mytable WHERE (DivTailNums[1] IN ('N3751B', 
'N296WN', 'N416SW', 'N472WN') OR DivTailNums[2] IN ('N3751B', 'N296WN', 
'N416SW', 'N472WN') OR DivTailNums[3] IN ('N3751B', 'N296WN', 'N416SW', 
'N472WN') OR DivTailNums[4] IN ('N3751B', 'N296WN', 'N416SW', 'N472WN') OR 
DivTailNums[5] IN ('N3751B', 'N296WN', 'N416SW', 'N472WN')) LIMIT 10000"]}
+{"sql":"SELECT SUM(DivActualElapsedTime), COUNT(LateAircraftDelay), 
AVG(DivActualElapsedTime) FROM mytable WHERE DivTotalGTimes > 18 AND 
OriginCityMarketID IN (30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 
AND 1 LIMIT 22","hsqls":["SELECT SUM(DivActualElapsedTime), 
COUNT(LateAircraftDelay), AVG(DivActualElapsedTime)  FROM mytable WHERE 
(DivTotalGTimes[1] > 18 OR DivTotalGTimes[2] > 18 OR DivTotalGTimes[3] > 18 OR 
DivTotalGTimes[4] > 18 OR DivTotalGTimes[5] > 18) AND OriginCityMarketID IN 
(30721, 32389, 30781, 31076) OR DepDel15 BETWEEN -9999 AND 1 LIMIT 10000"]}
+{"sql":"SELECT SUM(DivActualElapsedTime), MAX(\"Month\") FROM mytable WHERE 
Distance <> 788 AND DivWheelsOffs > 1851 LIMIT 5","hsqls":["SELECT 
SUM(DivActualElapsedTime), MAX(`Month`)  FROM mytable WHERE Distance <> 788 AND 
(DivWheelsOffs[1] > 1851 OR DivWheelsOffs[2] > 1851 OR DivWheelsOffs[3] > 1851 
OR DivWheelsOffs[4] > 1851 OR DivWheelsOffs[5] > 1851) LIMIT 10000"]}
+{"sql":"SELECT SUM(DivArrDelay), SUM(DestStateFips) FROM mytable WHERE 
DivTailNums IN ('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') AND 
DestAirportID < 11867 OR Carrier NOT IN ('DL', 'WN') LIMIT 20","hsqls":["SELECT 
SUM(DivArrDelay), SUM(DestStateFips)  FROM mytable WHERE (DivTailNums[1] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[2] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[3] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[4] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA') OR DivTailNums[5] IN 
('N3768', 'N438SW', 'N786SK', 'N636MQ', 'N3KXAA')) AND DestAirportID < 11867 OR 
Carrier NOT IN ('DL', 'WN') LIMIT 10000"]}
+{"sql":"SELECT SUM(DivReachedDest), AVG(DestWac) FROM mytable WHERE 
DivWheelsOns BETWEEN 728 AND 1804 LIMIT 13","hsqls":["SELECT 
SUM(DivReachedDest), AVG(DestWac)  FROM mytable WHERE (DivWheelsOns[1] BETWEEN 
728 AND 1804 OR DivWheelsOns[2] BETWEEN 728 AND 1804 OR DivWheelsOns[3] BETWEEN 
728 AND 1804 OR DivWheelsOns[4] BETWEEN 728 AND 1804 OR DivWheelsOns[5] BETWEEN 
728 AND 1804) LIMIT 10000"]}
+{"sql":"SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState) FROM mytable 
WHERE DivAirports IN ('RFD') AND TaxiIn BETWEEN -9999 AND 94 LIMIT 
29","hsqls":["SELECT SUM(WheelsOn), SUM(DivArrDelay), COUNT(DestState)  FROM 
mytable WHERE (DivAirports[1] IN ('RFD') OR DivAirports[2] IN ('RFD') OR 
DivAirports[3] IN ('RFD') OR DivAirports[4] IN ('RFD') OR DivAirports[5] IN 
('RFD')) AND TaxiIn BETWEEN -9999 AND 94 LIMIT 10000"]}
 {"sql":"SELECT SUM(\"Month\") FROM mytable WHERE FirstDepTime <> 1742 AND 
DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 
23","hsqls":["SELECT SUM(`Month`) FROM mytable WHERE FirstDepTime <> 1742 AND 
DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 23"]}
-{"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 
10","hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM 
mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes__MV0 IN (30, 113, 102, 37) 
OR DivTotalGTimes__MV1 IN (30, 113, 102, 37) OR DivTotalGTimes__MV2 IN (30, 
113, 102, 37) OR DivTotalGTimes__MV3 IN (30, 113, 102, 37) OR 
DivTotalGTimes__MV4 IN (30, 113, 102, 37)) LIMIT 10000"]}
+{"sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 
10","hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM 
mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes[1] IN (30, 113, 102, 37) OR 
DivTotalGTimes[2] IN (30, 113, 102, 37) OR DivTotalGTimes[3] IN (30, 113, 102, 
37) OR DivTotalGTimes[4] IN (30, 113, 102, 37) OR DivTotalGTimes[5] IN (30, 
113, 102, 37)) LIMIT 10000"]}

Review Comment:
   I dig a bit one thing is to change the query to use `ARRAY_CONTAINS`, e.g.
   ```
   {
   "sql":"SELECT SUM(\"Year\"), MAX(DayofMonth), AVG(CRSArrTime) FROM mytable 
WHERE WheelsOff > 1737 AND DivTotalGTimes IN (30, 113, 102, 37) LIMIT 10",
   "hsqls":["SELECT SUM(`Year`), MAX(DayofMonth), AVG(CRSArrTime)  FROM mytable 
WHERE (WheelsOff > 1737) AND (ARRAY_CONTAINS(DivTotalGTimes, 30) OR 
ARRAY_CONTAINS(DivTotalGTimes, 37) OR ARRAY_CONTAINS(DivTotalGTimes, 102) OR 
ARRAY_CONTAINS(DivTotalGTimes, 113)) LIMIT 10000"]}
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org