If a column name is not in lowecase, it cannot be queried without quoting.

[alexey-milovidov]

Description

> SELECT AVG(UserID) FROM 'hits.parquet';
Error: Schema error: No field named userid. Valid fields are "hits.parquet"."WatchID", "hits.parquet"."JavaEnable", "hits.parquet"."Title", "hits.parquet"."GoodEvent", "hits.parquet"."EventTime", "hits.parquet"."EventDate", "hits.parquet"."CounterID", "hits.parquet"."ClientIP", "hits.parquet"."RegionID", "hits.parquet"."UserID", "hits.parquet"."CounterClass", "hits.parquet"."OS", "hits.parquet"."UserAgent", "hits.parquet"."URL", "hits.parquet"."Referer", "hits.parquet"."IsRefresh", "hits.parquet"."RefererCategoryID", "hits.parquet"."RefererRegionID", "hits.parquet"."URLCategoryID", "hits.parquet"."URLRegionID", "hits.parquet"."ResolutionWidth", "hits.parquet"."ResolutionHeight", "hits.parquet"."ResolutionDepth", "hits.parquet"."FlashMajor", "hits.parquet"."FlashMinor", "hits.parquet"."FlashMinor2", "hits.parquet"."NetMajor", "hits.parquet"."NetMinor", "hits.parquet"."UserAgentMajor", "hits.parquet"."UserAgentMinor", "hits.parquet"."CookieEnable", "hits.parquet"."JavascriptEnable", "hits.parquet"."IsMobile", "hits.parquet"."MobilePhone", "hits.parquet"."MobilePhoneModel", "hits.parquet"."Params", "hits.parquet"."IPNetworkID", "hits.parquet"."TraficSourceID", "hits.parquet"."SearchEngineID", "hits.parquet"."SearchPhrase", "hits.parquet"."AdvEngineID", "hits.parquet"."IsArtifical", "hits.parquet"."WindowClientWidth", "hits.parquet"."WindowClientHeight", "hits.parquet"."ClientTimeZone", "hits.parquet"."ClientEventTime", "hits.parquet"."SilverlightVersion1", "hits.parquet"."SilverlightVersion2", "hits.parquet"."SilverlightVersion3", "hits.parquet"."SilverlightVersion4", "hits.parquet"."PageCharset", "hits.parquet"."CodeVersion", "hits.parquet"."IsLink", "hits.parquet"."IsDownload", "hits.parquet"."IsNotBounce", "hits.parquet"."FUniqID", "hits.parquet"."OriginalURL", "hits.parquet"."HID", "hits.parquet"."IsOldCounter", "hits.parquet"."IsEvent", "hits.parquet"."IsParameter", "hits.parquet"."DontCountHits", "hits.parquet"."WithHash", "hits.parquet"."HitColor", "hits.parquet"."LocalEventTime", "hits.parquet"."Age", "hits.parquet"."Sex", "hits.parquet"."Income", "hits.parquet"."Interests", "hits.parquet"."Robotness", "hits.parquet"."RemoteIP", "hits.parquet"."WindowName", "hits.parquet"."OpenerName", "hits.parquet"."HistoryLength", "hits.parquet"."BrowserLanguage", "hits.parquet"."BrowserCountry", "hits.parquet"."SocialNetwork", "hits.parquet"."SocialAction", "hits.parquet"."HTTPError", "hits.parquet"."SendTiming", "hits.parquet"."DNSTiming", "hits.parquet"."ConnectTiming", "hits.parquet"."ResponseStartTiming", "hits.parquet"."ResponseEndTiming", "hits.parquet"."FetchTiming", "hits.parquet"."SocialSourceNetworkID", "hits.parquet"."SocialSourcePage", "hits.parquet"."ParamPrice", "hits.parquet"."ParamOrderID", "hits.parquet"."ParamCurrency", "hits.parquet"."ParamCurrencyID", "hits.parquet"."OpenstatServiceName", "hits.parquet"."OpenstatCampaignID", "hits.parquet"."OpenstatAdID", "hits.parquet"."OpenstatSourceID", "hits.parquet"."UTMSource", "hits.parquet"."UTMMedium", "hits.parquet"."UTMCampaign", "hits.parquet"."UTMContent", "hits.parquet"."UTMTerm", "hits.parquet"."FromTag", "hits.parquet"."HasGCLID", "hits.parquet"."RefererHash", "hits.parquet"."URLHash", "hits.parquet"."CLID".

> SELECT AVG("hits.parquet".UserID) FROM 'hits.parquet';
Error: Schema error: No field named hits.parquet.userid. Valid fields are "hits.parquet"."WatchID", "hits.parquet"."JavaEnable", "hits.parquet"."Title", "hits.parquet"."GoodEvent", "hits.parquet"."EventTime", "hits.parquet"."EventDate", "hits.parquet"."CounterID", "hits.parquet"."ClientIP", "hits.parquet"."RegionID", "hits.parquet"."UserID", "hits.parquet"."CounterClass", "hits.parquet"."OS", "hits.parquet"."UserAgent", "hits.parquet"."URL", "hits.parquet"."Referer", "hits.parquet"."IsRefresh", "hits.parquet"."RefererCategoryID", "hits.parquet"."RefererRegionID", "hits.parquet"."URLCategoryID", "hits.parquet"."URLRegionID", "hits.parquet"."ResolutionWidth", "hits.parquet"."ResolutionHeight", "hits.parquet"."ResolutionDepth", "hits.parquet"."FlashMajor", "hits.parquet"."FlashMinor", "hits.parquet"."FlashMinor2", "hits.parquet"."NetMajor", "hits.parquet"."NetMinor", "hits.parquet"."UserAgentMajor", "hits.parquet"."UserAgentMinor", "hits.parquet"."CookieEnable", "hits.parquet"."JavascriptEnable", "hits.parquet"."IsMobile", "hits.parquet"."MobilePhone", "hits.parquet"."MobilePhoneModel", "hits.parquet"."Params", "hits.parquet"."IPNetworkID", "hits.parquet"."TraficSourceID", "hits.parquet"."SearchEngineID", "hits.parquet"."SearchPhrase", "hits.parquet"."AdvEngineID", "hits.parquet"."IsArtifical", "hits.parquet"."WindowClientWidth", "hits.parquet"."WindowClientHeight", "hits.parquet"."ClientTimeZone", "hits.parquet"."ClientEventTime", "hits.parquet"."SilverlightVersion1", "hits.parquet"."SilverlightVersion2", "hits.parquet"."SilverlightVersion3", "hits.parquet"."SilverlightVersion4", "hits.parquet"."PageCharset", "hits.parquet"."CodeVersion", "hits.parquet"."IsLink", "hits.parquet"."IsDownload", "hits.parquet"."IsNotBounce", "hits.parquet"."FUniqID", "hits.parquet"."OriginalURL", "hits.parquet"."HID", "hits.parquet"."IsOldCounter", "hits.parquet"."IsEvent", "hits.parquet"."IsParameter", "hits.parquet"."DontCountHits", "hits.parquet"."WithHash", "hits.parquet"."HitColor", "hits.parquet"."LocalEventTime", "hits.parquet"."Age", "hits.parquet"."Sex", "hits.parquet"."Income", "hits.parquet"."Interests", "hits.parquet"."Robotness", "hits.parquet"."RemoteIP", "hits.parquet"."WindowName", "hits.parquet"."OpenerName", "hits.parquet"."HistoryLength", "hits.parquet"."BrowserLanguage", "hits.parquet"."BrowserCountry", "hits.parquet"."SocialNetwork", "hits.parquet"."SocialAction", "hits.parquet"."HTTPError", "hits.parquet"."SendTiming", "hits.parquet"."DNSTiming", "hits.parquet"."ConnectTiming", "hits.parquet"."ResponseStartTiming", "hits.parquet"."ResponseEndTiming", "hits.parquet"."FetchTiming", "hits.parquet"."SocialSourceNetworkID", "hits.parquet"."SocialSourcePage", "hits.parquet"."ParamPrice", "hits.parquet"."ParamOrderID", "hits.parquet"."ParamCurrency", "hits.parquet"."ParamCurrencyID", "hits.parquet"."OpenstatServiceName", "hits.parquet"."OpenstatCampaignID", "hits.parquet"."OpenstatAdID", "hits.parquet"."OpenstatSourceID", "hits.parquet"."UTMSource", "hits.parquet"."UTMMedium", "hits.parquet"."UTMCampaign", "hits.parquet"."UTMContent", "hits.parquet"."UTMTerm", "hits.parquet"."FromTag", "hits.parquet"."HasGCLID", "hits.parquet"."RefererHash", "hits.parquet"."URLHash", "hits.parquet"."CLID".

> SELECT AVG("UserID") FROM 'hits.parquet';
┌───────────────────────────┐
│  AVG(hits.parquet.UserID) │
│                        ── │
│                   Float64 │
╞═══════════════════════════╡
│ 2528953029789716992.00000 │
└───────────────────────────┘

For comparison, ClickHouse does it perfectly:

ubuntu@ip-172-31-38-111:~$ ./clickhouse 
ClickHouse local version 24.2.1.218 (official build).

ip-172-31-38-111.eu-central-1.compute.internal :) SELECT AVG(UserID) FROM 'hits.parquet'

[universalmind303]

duplicate of https://github.com/GlareDB/glaredb/issues/1406