'1046: Cannot parse value:Ok("5632622125792883430") to number type, cause: Overflow(5)' on loading hits data

[flaneur2020]

Version

0.7.121-nightly

Summary

Schema:

CREATE TABLE `hits` ( `WatchID` BIGINT, `JavaEnable` SMALLINT, `Title` VARCHAR, `GoodEvent` SMALLINT, `EventTime` TIMESTAMP(6), `EventDate` DATE, `CounterID` INT, `ClientIP` INT, `RegionID` INT, `UserID` BIGINT, `CounterClass` SMALLINT, `OS` SMALLINT, `UserAgent` SMALLINT, `URL` VARCHAR, `Referer` VARCHAR, `IsRefresh` SMALLINT, `RefererCategoryID` SMALLINT, `RefererRegionID` INT, `URLCategoryID` SMALLINT, `URLRegionID` INT, `ResolutionWidth` SMALLINT, `ResolutionHeight` SMALLINT, `ResolutionDepth` SMALLINT, `FlashMajor` SMALLINT, `FlashMinor` SMALLINT, `FlashMinor2` VARCHAR, `NetMajor` SMALLINT, `NetMinor` SMALLINT, `UserAgentMajor` SMALLINT, `UserAgentMinor` VARCHAR, `CookieEnable` SMALLINT, `JavascriptEnable` SMALLINT, `IsMobile` SMALLINT, `MobilePhone` SMALLINT, `MobilePhoneModel` VARCHAR, `Params` VARCHAR, `IPNetworkID` INT, `TraficSourceID` SMALLINT, `SearchEngineID` SMALLINT, `SearchPhrase` VARCHAR, `AdvEngineID` SMALLINT, `IsArtifical` SMALLINT, `WindowClientWidth` SMALLINT, `WindowClientHeight` SMALLINT, `ClientTimeZone` SMALLINT, `ClientEventTime` TIMESTAMP(6), `SilverlightVersion1` SMALLINT, `SilverlightVersion2` SMALLINT, `SilverlightVersion3` INT, `SilverlightVersion4` SMALLINT, `PageCharset` VARCHAR, `CodeVersion` INT, `IsLink` SMALLINT, `IsDownload` SMALLINT, `IsNotBounce` SMALLINT, `FUniqID` BIGINT, `OriginalURL` VARCHAR, `HID` INT, `IsOldCounter` SMALLINT, `IsEvent` SMALLINT, `IsParameter` SMALLINT, `DontCountHits` SMALLINT, `WithHash` SMALLINT, `HitColor` VARCHAR, `LocalEventTime` TIMESTAMP(6), `Age` SMALLINT, `Sex` SMALLINT, `Income` SMALLINT, `Interests` SMALLINT, `Robotness` SMALLINT, `RemoteIP` INT, `WindowName` INT, `OpenerName` INT, `HistoryLength` SMALLINT, `BrowserLanguage` VARCHAR, `BrowserCountry` VARCHAR, `SocialNetwork` VARCHAR, `SocialAction` VARCHAR, `HTTPError` SMALLINT, `SendTiming` INT, `DNSTiming` INT, `ConnectTiming` INT, `ResponseStartTiming` INT, `ResponseEndTiming` INT, `FetchTiming` INT, `SocialSourceNetworkID` SMALLINT, `SocialSourcePage` VARCHAR, `ParamPrice` BIGINT, `ParamOrderID` VARCHAR, `ParamCurrency` VARCHAR, `ParamCurrencyID` SMALLINT, `OpenstatServiceName` VARCHAR, `OpenstatCampaignID` VARCHAR, `OpenstatAdID` VARCHAR, `OpenstatSourceID` VARCHAR, `UTMSource` VARCHAR, `UTMMedium` VARCHAR, `UTMCampaign` VARCHAR, `UTMContent` VARCHAR, `UTMTerm` VARCHAR, `FromTag` VARCHAR, `HasGCLID` SMALLINT, `RefererHash` BIGINT, `URLHash` BIGINT, `CLID` INT) ENGINE=FUSE CLUSTER BY (CounterID, EventDate, UserID, EventTime, WatchID)

Query:

COPY INTO hits FROM '@hits' files=('hits_bug.csv') file_format = (type = 'csv' field_delimiter = "\t" record_delimiter = "\n" skip_header = 0);

Data:

hits_bug.csv

Error:

1046: Cannot parse value:Ok("5632622125792883430") to number type, cause: Overflow(5) (while in processor thread 0)

[BohuTANG]

After this patch is merged, we can easy to debug it:
#6530

[Xuanwo]

#6530 has been merged, please try again.

[fkuner]

#6530 can't do it. Because copy into use the old method to parse csv. I have issued it in #6531.