abhioncbr commented on code in PR #10561:
URL: https://github.com/apache/pinot/pull/10561#discussion_r1161098389
##########
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:
True, the `ARRAY_CONTAINS` function only searches for one value. Let me
change to the `ARRAY_CONTAINS` style.
--
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
