CreateQuery fixed_granularity_table (children 3) Identifier fixed_granularity_table Columns definition (children 1) ExpressionList (children 133) ColumnDeclaration WatchID (children 1) DataType UInt64 ColumnDeclaration JavaEnable (children 1) DataType UInt8 ColumnDeclaration Title (children 1) DataType String ColumnDeclaration GoodEvent (children 1) DataType Int16 ColumnDeclaration EventTime (children 1) DataType DateTime ColumnDeclaration EventDate (children 1) DataType Date ColumnDeclaration CounterID (children 1) DataType UInt32 ColumnDeclaration ClientIP (children 1) DataType UInt32 ColumnDeclaration ClientIP6 (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_16 ColumnDeclaration RegionID (children 1) DataType UInt32 ColumnDeclaration UserID (children 1) DataType UInt64 ColumnDeclaration CounterClass (children 1) DataType Int8 ColumnDeclaration OS (children 1) DataType UInt8 ColumnDeclaration UserAgent (children 1) DataType UInt8 ColumnDeclaration URL (children 1) DataType String ColumnDeclaration Referer (children 1) DataType String ColumnDeclaration URLDomain (children 1) DataType String ColumnDeclaration RefererDomain (children 1) DataType String ColumnDeclaration Refresh (children 1) DataType UInt8 ColumnDeclaration IsRobot (children 1) DataType UInt8 ColumnDeclaration RefererCategories (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt16 ColumnDeclaration URLCategories (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt16 ColumnDeclaration URLRegions (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt32 ColumnDeclaration RefererRegions (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt32 ColumnDeclaration ResolutionWidth (children 1) DataType UInt16 ColumnDeclaration ResolutionHeight (children 1) DataType UInt16 ColumnDeclaration ResolutionDepth (children 1) DataType UInt8 ColumnDeclaration FlashMajor (children 1) DataType UInt8 ColumnDeclaration FlashMinor (children 1) DataType UInt8 ColumnDeclaration FlashMinor2 (children 1) DataType String ColumnDeclaration NetMajor (children 1) DataType UInt8 ColumnDeclaration NetMinor (children 1) DataType UInt8 ColumnDeclaration UserAgentMajor (children 1) DataType UInt16 ColumnDeclaration UserAgentMinor (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_2 ColumnDeclaration CookieEnable (children 1) DataType UInt8 ColumnDeclaration JavascriptEnable (children 1) DataType UInt8 ColumnDeclaration IsMobile (children 1) DataType UInt8 ColumnDeclaration MobilePhone (children 1) DataType UInt8 ColumnDeclaration MobilePhoneModel (children 1) DataType String ColumnDeclaration Params (children 1) DataType String ColumnDeclaration IPNetworkID (children 1) DataType UInt32 ColumnDeclaration TraficSourceID (children 1) DataType Int8 ColumnDeclaration SearchEngineID (children 1) DataType UInt16 ColumnDeclaration SearchPhrase (children 1) DataType String ColumnDeclaration AdvEngineID (children 1) DataType UInt8 ColumnDeclaration IsArtifical (children 1) DataType UInt8 ColumnDeclaration WindowClientWidth (children 1) DataType UInt16 ColumnDeclaration WindowClientHeight (children 1) DataType UInt16 ColumnDeclaration ClientTimeZone (children 1) DataType Int16 ColumnDeclaration ClientEventTime (children 1) DataType DateTime ColumnDeclaration SilverlightVersion1 (children 1) DataType UInt8 ColumnDeclaration SilverlightVersion2 (children 1) DataType UInt8 ColumnDeclaration SilverlightVersion3 (children 1) DataType UInt32 ColumnDeclaration SilverlightVersion4 (children 1) DataType UInt16 ColumnDeclaration PageCharset (children 1) DataType String ColumnDeclaration CodeVersion (children 1) DataType UInt32 ColumnDeclaration IsLink (children 1) DataType UInt8 ColumnDeclaration IsDownload (children 1) DataType UInt8 ColumnDeclaration IsNotBounce (children 1) DataType UInt8 ColumnDeclaration FUniqID (children 1) DataType UInt64 ColumnDeclaration HID (children 1) DataType UInt32 ColumnDeclaration IsOldCounter (children 1) DataType UInt8 ColumnDeclaration IsEvent (children 1) DataType UInt8 ColumnDeclaration IsParameter (children 1) DataType UInt8 ColumnDeclaration DontCountHits (children 1) DataType UInt8 ColumnDeclaration WithHash (children 1) DataType UInt8 ColumnDeclaration HitColor (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_1 ColumnDeclaration UTCEventTime (children 1) DataType DateTime ColumnDeclaration Age (children 1) DataType UInt8 ColumnDeclaration Sex (children 1) DataType UInt8 ColumnDeclaration Income (children 1) DataType UInt8 ColumnDeclaration Interests (children 1) DataType UInt16 ColumnDeclaration Robotness (children 1) DataType UInt8 ColumnDeclaration GeneralInterests (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt16 ColumnDeclaration RemoteIP (children 1) DataType UInt32 ColumnDeclaration RemoteIP6 (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_16 ColumnDeclaration WindowName (children 1) DataType Int32 ColumnDeclaration OpenerName (children 1) DataType Int32 ColumnDeclaration HistoryLength (children 1) DataType Int16 ColumnDeclaration BrowserLanguage (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_2 ColumnDeclaration BrowserCountry (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_2 ColumnDeclaration SocialNetwork (children 1) DataType String ColumnDeclaration SocialAction (children 1) DataType String ColumnDeclaration HTTPError (children 1) DataType UInt16 ColumnDeclaration SendTiming (children 1) DataType Int32 ColumnDeclaration DNSTiming (children 1) DataType Int32 ColumnDeclaration ConnectTiming (children 1) DataType Int32 ColumnDeclaration ResponseStartTiming (children 1) DataType Int32 ColumnDeclaration ResponseEndTiming (children 1) DataType Int32 ColumnDeclaration FetchTiming (children 1) DataType Int32 ColumnDeclaration RedirectTiming (children 1) DataType Int32 ColumnDeclaration DOMInteractiveTiming (children 1) DataType Int32 ColumnDeclaration DOMContentLoadedTiming (children 1) DataType Int32 ColumnDeclaration DOMCompleteTiming (children 1) DataType Int32 ColumnDeclaration LoadEventStartTiming (children 1) DataType Int32 ColumnDeclaration LoadEventEndTiming (children 1) DataType Int32 ColumnDeclaration NSToDOMContentLoadedTiming (children 1) DataType Int32 ColumnDeclaration FirstPaintTiming (children 1) DataType Int32 ColumnDeclaration RedirectCount (children 1) DataType Int8 ColumnDeclaration SocialSourceNetworkID (children 1) DataType UInt8 ColumnDeclaration SocialSourcePage (children 1) DataType String ColumnDeclaration ParamPrice (children 1) DataType Int64 ColumnDeclaration ParamOrderID (children 1) DataType String ColumnDeclaration ParamCurrency (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_3 ColumnDeclaration ParamCurrencyID (children 1) DataType UInt16 ColumnDeclaration GoalsReached (children 1) DataType Array (children 1) ExpressionList (children 1) DataType UInt32 ColumnDeclaration OpenstatServiceName (children 1) DataType String ColumnDeclaration OpenstatCampaignID (children 1) DataType String ColumnDeclaration OpenstatAdID (children 1) DataType String ColumnDeclaration OpenstatSourceID (children 1) DataType String ColumnDeclaration UTMSource (children 1) DataType String ColumnDeclaration UTMMedium (children 1) DataType String ColumnDeclaration UTMCampaign (children 1) DataType String ColumnDeclaration UTMContent (children 1) DataType String ColumnDeclaration UTMTerm (children 1) DataType String ColumnDeclaration FromTag (children 1) DataType String ColumnDeclaration HasGCLID (children 1) DataType UInt8 ColumnDeclaration RefererHash (children 1) DataType UInt64 ColumnDeclaration URLHash (children 1) DataType UInt64 ColumnDeclaration CLID (children 1) DataType UInt32 ColumnDeclaration YCLID (children 1) DataType UInt64 ColumnDeclaration ShareService (children 1) DataType String ColumnDeclaration ShareURL (children 1) DataType String ColumnDeclaration ShareTitle (children 1) DataType String ColumnDeclaration ParsedParams.Key1 (children 1) DataType Array (children 1) ExpressionList (children 1) DataType String ColumnDeclaration ParsedParams.Key2 (children 1) DataType Array (children 1) ExpressionList (children 1) DataType String ColumnDeclaration ParsedParams.Key3 (children 1) DataType Array (children 1) ExpressionList (children 1) DataType String ColumnDeclaration ParsedParams.Key4 (children 1) DataType Array (children 1) ExpressionList (children 1) DataType String ColumnDeclaration ParsedParams.Key5 (children 1) DataType Array (children 1) ExpressionList (children 1) DataType String ColumnDeclaration ParsedParams.ValueDouble (children 1) DataType Array (children 1) ExpressionList (children 1) DataType Float64 ColumnDeclaration IslandID (children 1) DataType FixedString (children 1) ExpressionList (children 1) Literal UInt64_16 ColumnDeclaration RequestNum (children 1) DataType UInt32 ColumnDeclaration RequestTry (children 1) DataType UInt8 Storage definition (children 5) Function MergeTree (children 1) ExpressionList Function toYYYYMM (children 1) ExpressionList (children 1) Identifier EventDate Function tuple (children 1) ExpressionList (children 3) Identifier CounterID Identifier EventDate Function intHash32 (children 1) ExpressionList (children 1) Identifier UserID Function intHash32 (children 1) ExpressionList (children 1) Identifier UserID Set