Created
January 27, 2022 10:54
-
-
Save alexey-milovidov/9114ad88b1445be50f4f4bc718edcccc to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| milovidov@milovidov-desktop:~/work/ClickHouse/docs/tools$ clickhouse-client | |
| ClickHouse client version 22.2.1.1. | |
| Connecting to localhost:9000 as user default. | |
| Connected to ClickHouse server version 22.2.1 revision 54455. | |
| milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all MATERIALIZED formatRow('TSV', *) | |
| ALTER TABLE test.hits | |
| ADD COLUMN `all` MATERIALIZED formatRow('TSV', *) | |
| Query id: 6c3a3bed-0aaf-43df-b0c5-7c3929152d32 | |
| 0 rows in set. Elapsed: 0.010 sec. | |
| Received exception from server (version 22.2.1): | |
| Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Data type have to be specified for column `all` to add. (BAD_ARGUMENTS) | |
| milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all String MATERIALIZED formatRow('TSV', *) | |
| ALTER TABLE test.hits | |
| ADD COLUMN `all` String MATERIALIZED formatRow('TSV', *) | |
| Query id: 3dacbf60-4a10-48e9-b48b-a8b9db6974ef | |
| 0 rows in set. Elapsed: 0.017 sec. | |
| Received exception from server (version 22.2.1): | |
| Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: *; there are columns: 'TSV': While processing _CAST(formatRow('TSV', *) AS all_tmp_alter1720335579804109044, 'String') AS `all`: default expression and column type are incompatible.. (UNKNOWN_IDENTIFIER) | |
| milovidov-desktop :) EXPLAIN SYNTAX SELECT formatRow('TSV', *) FROM test.hits | |
| EXPLAIN SYNTAX | |
| SELECT formatRow('TSV', *) | |
| FROM test.hits | |
| Query id: e0592d01-3665-4951-8504-6c7ac57c7ef2 | |
| ββexplainβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ | |
| β SELECT formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTerm, FromTag, HasGCLID, RefererHash, URLHash, CLID, YCLID, ShareService, ShareURL, ShareTitle, `ParsedParams.Key1`, `ParsedParams.Key2`, `ParsedParams.Key3`, `ParsedParams.Key4`, `ParsedParams.Key5`, `ParsedParams.ValueDouble`, IslandID, RequestNum, RequestTry) β | |
| β FROM test.hits β | |
| ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ | |
| 2 rows in set. Elapsed: 0.007 sec. | |
| milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all String MATERIALIZED formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTerm, FromTag, HasGCLID, RefererHash, URLHash, CLID, YCLID, ShareService, ShareURL, ShareTitle, `ParsedParams.Key1`, `ParsedParams.Key2`, `ParsedParams.Key3`, `ParsedParams.Key4`, `ParsedParams.Key5`, `ParsedParams.ValueDouble`, IslandID, RequestNum, RequestTry) | |
| ALTER TABLE test.hits | |
| ADD COLUMN `all` String MATERIALIZED formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTerm, FromTag, HasGCLID, RefererHash, URLHash, CLID, YCLID, ShareService, ShareURL, ShareTitle, `ParsedParams.Key1`, `ParsedParams.Key2`, `ParsedParams.Key3`, `ParsedParams.Key4`, `ParsedParams.Key5`, `ParsedParams.ValueDouble`, IslandID, RequestNum, RequestTry) | |
| Query id: b1e9044e-4739-4be1-a952-d7755380e07b | |
| Ok. | |
| 0 rows in set. Elapsed: 0.014 sec. | |
| milovidov-desktop :) ALTER TABLE test.hits MATERIALIZE COLUMN `all` | |
| ALTER TABLE test.hits | |
| MATERIALIZE COLUMN `all` | |
| Query id: 540c6889-696d-437f-a84a-d04e4101e1b3 | |
| Ok. | |
| 0 rows in set. Elapsed: 0.007 sec. | |
| milovidov-desktop :) SELECT * FROM system.mu | |
| multiFuzzyMatchAllIndices multiMatchAnyIndex multiSearchAnyCaseInsensitive multiSearchFirstIndexUTF8 multiply mushrooms | |
| multiFuzzyMatchAny multiSearchAllPositions multiSearchAnyCaseInsensitiveUTF8 multiSearchFirstPosition murmurHash2_32 mutation_id | |
| multiFuzzyMatchAnyIndex multiSearchAllPositionsCaseInsensitive multiSearchAnyUTF8 multiSearchFirstPositionCaseInsensitive murmurHash2_64 mutations | |
| multiIf multiSearchAllPositionsCaseInsensitiveUTF8 multiSearchFirstIndex multiSearchFirstPositionCaseInsensitiveUTF8 murmurHash3_128 mutations_sync | |
| multiMatchAllIndices multiSearchAllPositionsUTF8 multiSearchFirstIndexCaseInsensitive multiSearchFirstPositionUTF8 murmurHash3_32 | |
| multiMatchAny multiSearchAny multiSearchFirstIndexCaseInsensitiveUTF8 multiple_joins_rewriter_version murmurHash3_64 | |
| milovidov-desktop :) SELECT * FROM system.mutations | |
| SELECT * | |
| FROM system.mutations | |
| Query id: 0ab2c8a2-da44-4ec6-8275-98538abfcfef | |
| ββdatabaseββ¬βtableβββ¬βmutation_idβββββββ¬βcommandβββββββββββββββββββββ¬βββββββββcreate_timeββ¬βblock_numbers.partition_idββ¬βblock_numbers.numberββ¬βparts_to_do_namesββ¬βparts_to_doββ¬βis_doneββ¬βlatest_failed_partββ¬ββββlatest_fail_timeββ¬βlatest_fail_reasonββ | |
| β default β t_ren2 β mutation_119.txt β UPDATE age1 = age1 WHERE 1 β 2021-07-02 04:18:30 β [''] β [119] β [] β 0 β 1 β β 1970-01-01 03:00:00 β β | |
| β default β t_ren2 β mutation_120.txt β UPDATE agg = agg WHERE 1 β 2021-07-02 04:18:44 β [''] β [120] β [] β 0 β 1 β β 1970-01-01 03:00:00 β β | |
| β test β hits β mutation_19.txt β MATERIALIZE COLUMN `all` β 2022-01-27 13:49:54 β [''] β [19] β [] β 0 β 1 β β 1970-01-01 03:00:00 β β | |
| ββββββββββββ΄βββββββββ΄βββββββββββββββββββ΄βββββββββββββββββββββββββββββ΄ββββββββββββββββββββββ΄βββββββββββββββββββββββββββββ΄βββββββββββββββββββββββ΄ββββββββββββββββββββ΄ββββββββββββββ΄ββββββββββ΄βββββββββββββββββββββ΄ββββββββββββββββββββββ΄βββββββββββββββββββββ | |
| 3 rows in set. Elapsed: 0.003 sec. | |
| milovidov-desktop :) SELECT * FROM system.merges | |
| SELECT * | |
| FROM system.merges | |
| Query id: 300c518b-d9ea-48df-a52d-e5a97b6454f4 | |
| Ok. | |
| 0 rows in set. Elapsed: 0.002 sec. | |
| milovidov-desktop :) SELECT * FROM system.col | |
| collation_catalog collations column_comment column_default column_position columns_version | |
| collation_name column column_data_compressed_bytes column_marks_bytes column_type columns_written | |
| collation_schema column_bytes_on_disk column_data_uncompressed_bytes column_name columns | |
| milovidov-desktop :) SELECT * FROM system.columns WHERE table = 'hits' AND database = 'test' | |
| SELECT * | |
| FROM system.columns | |
| WHERE (table = 'hits') AND (database = 'test') | |
| Query id: c2709eff-acda-4e55-a26d-9bd772f8e4d5 | |
| ββdatabaseββ¬βtableββ¬βnameββββββββββββββββββββββββ¬βtypeβββββββββββββ¬βpositionββ¬βdefault_kindββ¬βdefault_expressionββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ¬βdata_compressed_bytesββ¬βdata_uncompressed_bytesββ¬βmarks_bytesββ¬βcommentββ¬βis_in_partition_keyββ¬βis_in_sorting_keyββ¬βis_in_primary_keyββ¬βis_in_sampling_keyββ¬βcompression_codecββ¬βcharacter_octet_lengthββ¬βnumeric_precisionββ¬βnumeric_precision_radixββ¬βnumeric_scaleββ¬βdatetime_precisionββ | |
| β test β hits β WatchID β UInt64 β 1 β β β 71297213 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β JavaEnable β UInt8 β 2 β β β 1407256 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Title β String β 3 β β β 166325706 β 697885258 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β GoodEvent β Int16 β 4 β β β 79355 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β EventTime β DateTime β 5 β β β 32944255 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β 0 β | |
| β test β hits β EventDate β Date β 6 β β β 919521 β 17747796 β 17344 β β 1 β 1 β 1 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β 0 β | |
| β test β hits β CounterID β UInt32 β 7 β β β 688582 β 35495592 β 17344 β β 0 β 1 β 1 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ClientIP β UInt32 β 8 β β β 8284187 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ClientIP6 β FixedString(16) β 9 β β β 8270539 β 141982368 β 17344 β β 0 β 0 β 0 β 0 β β 16 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RegionID β UInt32 β 10 β β β 5292159 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UserID β UInt64 β 11 β β β 11620687 β 70991184 β 17344 β β 0 β 1 β 1 β 1 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β CounterClass β Int8 β 12 β β β 128838 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OS β UInt8 β 13 β β β 2113488 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UserAgent β UInt8 β 14 β β β 2411636 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β URL β String β 15 β β β 194063900 β 697963246 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Referer β String β 16 β β β 225996870 β 641999783 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β URLDomain β String β 17 β β β 6219318 β 150759693 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RefererDomain β String β 18 β β β 10081666 β 90229996 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Refresh β UInt8 β 19 β β β 815657 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsRobot β UInt8 β 20 β β β 305626 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RefererCategories β Array(UInt16) β 21 β β β 12932968 β 154038338 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β URLCategories β Array(UInt16) β 22 β β β 5646503 β 178036672 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β URLRegions β Array(UInt32) β 23 β β β 4131803 β 116996576 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RefererRegions β Array(UInt32) β 24 β β β 10683017 β 104751372 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ResolutionWidth β UInt16 β 25 β β β 3721816 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ResolutionHeight β UInt16 β 26 β β β 3627643 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ResolutionDepth β UInt8 β 27 β β β 1793633 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FlashMajor β UInt8 β 28 β β β 1687600 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FlashMinor β UInt8 β 29 β β β 1049716 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FlashMinor2 β String β 30 β β β 2648449 β 28107876 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β NetMajor β UInt8 β 31 β β β 292213 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β NetMinor β UInt8 β 32 β β β 268274 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UserAgentMajor β UInt16 β 33 β β β 3617295 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UserAgentMinor β FixedString(2) β 34 β β β 1696638 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β 2 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β CookieEnable β UInt8 β 35 β β β 67390 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β JavascriptEnable β UInt8 β 36 β β β 86251 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsMobile β UInt8 β 37 β β β 861141 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β MobilePhone β UInt8 β 38 β β β 824726 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β MobilePhoneModel β String β 39 β β β 1312567 β 16988875 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Params β String β 40 β β β 4521423 β 61499924 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IPNetworkID β UInt32 β 41 β β β 6130039 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β TraficSourceID β Int8 β 42 β β β 4052435 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SearchEngineID β UInt16 β 43 β β β 1934734 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SearchPhrase β String β 44 β β β 11264172 β 41723536 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β AdvEngineID β UInt8 β 45 β β β 117020 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsArtifical β UInt8 β 46 β β β 2891673 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β WindowClientWidth β UInt16 β 47 β β β 5277056 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β WindowClientHeight β UInt16 β 48 β β β 5710086 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ClientTimeZone β Int16 β 49 β β β 2814632 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ClientEventTime β DateTime β 50 β β β 33324540 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β 0 β | |
| β test β hits β SilverlightVersion1 β UInt8 β 51 β β β 1612564 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SilverlightVersion2 β UInt8 β 52 β β β 1397386 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SilverlightVersion3 β UInt32 β 53 β β β 2599433 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SilverlightVersion4 β UInt16 β 54 β β β 79204 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β PageCharset β String β 55 β β β 323271 β 52784081 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β CodeVersion β UInt32 β 56 β β β 4061154 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsLink β UInt8 β 57 β β β 946865 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsDownload β UInt8 β 58 β β β 220602 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsNotBounce β UInt8 β 59 β β β 2417284 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FUniqID β UInt64 β 60 β β β 9480380 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β HID β UInt32 β 61 β β β 28508332 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsOldCounter β UInt8 β 62 β β β 39585 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsEvent β UInt8 β 63 β β β 39559 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IsParameter β UInt8 β 64 β β β 376062 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β DontCountHits β UInt8 β 65 β β β 2995477 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β WithHash β UInt8 β 66 β β β 132394 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β HitColor β FixedString(1) β 67 β β β 1906566 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β 1 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTCEventTime β DateTime β 68 β β β 32935155 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β 0 β | |
| β test β hits β Age β UInt8 β 69 β β β 2515607 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Sex β UInt8 β 70 β β β 2121640 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Income β UInt8 β 71 β β β 2075886 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Interests β UInt16 β 72 β β β 3193790 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β Robotness β UInt8 β 73 β β β 1467628 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β GeneralInterests β Array(UInt16) β 74 β β β 16940908 β 160192350 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RemoteIP β UInt32 β 75 β β β 7971474 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RemoteIP6 β FixedString(16) β 76 β β β 7981528 β 141982368 β 17344 β β 0 β 0 β 0 β 0 β β 16 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β WindowName β Int32 β 77 β β β 6592594 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OpenerName β Int32 β 78 β β β 158180 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β HistoryLength β Int16 β 79 β β β 4016542 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β BrowserLanguage β FixedString(2) β 80 β β β 931011 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β 2 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β BrowserCountry β FixedString(2) β 81 β β β 2159231 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β 2 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SocialNetwork β String β 82 β β β 39559 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SocialAction β String β 83 β β β 39559 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β HTTPError β UInt16 β 84 β β β 79084 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SendTiming β Int32 β 85 β β β 6188308 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β DNSTiming β Int32 β 86 β β β 7829885 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ConnectTiming β Int32 β 87 β β β 9599350 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ResponseStartTiming β Int32 β 88 β β β 15166250 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ResponseEndTiming β Int32 β 89 β β β 15070582 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FetchTiming β Int32 β 90 β β β 9790081 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RedirectTiming β Int32 β 91 β β β 6961682 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β DOMInteractiveTiming β Int32 β 92 β β β 12842870 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β DOMContentLoadedTiming β Int32 β 93 β β β 10589125 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β DOMCompleteTiming β Int32 β 94 β β β 6319977 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β LoadEventStartTiming β Int32 β 95 β β β 6308307 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β LoadEventEndTiming β Int32 β 96 β β β 5233874 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β NSToDOMContentLoadedTiming β Int32 β 97 β β β 11773347 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FirstPaintTiming β Int32 β 98 β β β 7408842 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RedirectCount β Int8 β 99 β β β 39559 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SocialSourceNetworkID β UInt8 β 100 β β β 268699 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β SocialSourcePage β String β 101 β β β 336259 β 9785668 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParamPrice β Int64 β 102 β β β 322028 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParamOrderID β String β 103 β β β 47958 β 8890264 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParamCurrency β FixedString(3) β 104 β β β 122763 β 26621694 β 17344 β β 0 β 0 β 0 β 0 β β 3 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParamCurrencyID β UInt16 β 105 β β β 83064 β 17747796 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 16 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β GoalsReached β Array(UInt32) β 106 β β β 2820037 β 80579276 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OpenstatServiceName β String β 107 β β β 92774 β 9058027 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OpenstatCampaignID β String β 108 β β β 111583 β 8963071 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OpenstatAdID β String β 109 β β β 126985 β 8979377 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β OpenstatSourceID β String β 110 β β β 104257 β 9057854 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTMSource β String β 111 β β β 460308 β 10081691 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTMMedium β String β 112 β β β 426800 β 9802611 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTMCampaign β String β 113 β β β 539618 β 10247909 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTMContent β String β 114 β β β 252197 β 9211692 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β UTMTerm β String β 115 β β β 185005 β 9129843 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β FromTag β String β 116 β β β 498297 β 11697166 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β HasGCLID β UInt8 β 117 β β β 82927 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RefererHash β UInt64 β 118 β β β 28448418 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β URLHash β UInt64 β 119 β β β 37312066 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β CLID β UInt32 β 120 β β β 761158 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β YCLID β UInt64 β 121 β β β 396360 β 70991184 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 64 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ShareService β String β 122 β β β 42504 β 8877693 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ShareURL β String β 123 β β β 46921 β 8886658 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ShareTitle β String β 124 β β β 51145 β 8890795 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.Key1 β Array(String) β 125 β β β 3101391 β 84216439 β 34688 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.Key2 β Array(String) β 126 β β β 1146350 β 9885298 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.Key3 β Array(String) β 127 β β β 465560 β 4080731 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.Key4 β Array(String) β 128 β β β 137006 β 1358390 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.Key5 β Array(String) β 129 β β β 20496 β 1109962 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β ParsedParams.ValueDouble β Array(Float64) β 130 β β β 8240976 β 8206608 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β IslandID β FixedString(16) β 131 β β β 613951 β 141982368 β 17344 β β 0 β 0 β 0 β 0 β β 16 β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RequestNum β UInt32 β 132 β β β 14594145 β 35495592 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 32 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β RequestTry β UInt8 β 133 β β β 2976883 β 8873898 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β 8 β 2 β 0 β α΄Ία΅α΄Έα΄Έ β | |
| β test β hits β all β String β 134 β MATERIALIZED β formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTerm, FromTag, HasGCLID, RefererHash, URLHash, CLID, YCLID, ShareService, ShareURL, ShareTitle, `ParsedParams.Key1`, `ParsedParams.Key2`, `ParsedParams.Key3`, `ParsedParams.Key4`, `ParsedParams.Key5`, `ParsedParams.ValueDouble`, IslandID, RequestNum, RequestTry) β 1965629079 β 7802191583 β 17344 β β 0 β 0 β 0 β 0 β β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β α΄Ία΅α΄Έα΄Έ β | |
| ββββββββββββ΄ββββββββ΄βββββββββββββββββββββββββββββ΄ββββββββββββββββββ΄βββββββββββ΄βββββββββββββββ΄βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββ΄ββββββββββββββββββββββββββ΄ββββββββββββββ΄ββββββββββ΄ββββββββββββββββββββββ΄ββββββββββββββββββββ΄ββββββββββββββββββββ΄βββββββββββββββββββββ΄ββββββββββββββββββββ΄βββββββββββββββββββββββββ΄ββββββββββββββββββββ΄ββββββββββββββββββββββββββ΄ββββββββββββββββ΄βββββββββββββββββββββ | |
| 134 rows in set. Elapsed: 0.013 sec. | |
| milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all String MATERIALIZED formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTemilovidov-desktop :) SELECT extractTextFromHTML(*) | |
| milovidov-desktop :) SELECT uniqExact(title) | |
| FROM remoteSecure('gh-api.clickhouse.tech', | |
| default.github_events, | |
| milovidov-desktop :) SELECT count() FROM test.hits WHERE `all` ILIKE '%xyz%' | |
| SELECT count() | |
| FROM test.hits | |
| WHERE `all` ILIKE '%xyz%' | |
| Query id: 0c17738d-89c4-4ffe-8d4e-4b1c91d91529 | |
| ββcount()ββ | |
| β 3725 β | |
| βββββββββββ | |
| 1 rows in set. Elapsed: 1.109 sec. Processed 8.87 million rows, 7.86 GB (8.00 million rows/s., 7.09 GB/s.) | |
| milovidov-desktop :) SELECT count() FROM test.hits WHERE `all` ILIKE '%xyz%' | |
| SELECT count() | |
| FROM test.hits | |
| WHERE `all` ILIKE '%xyz%' | |
| Query id: 0507db4e-ad96-481d-8f96-3bfae69b173b | |
| ββcount()ββ | |
| β 3725 β | |
| βββββββββββ | |
| 1 rows in set. Elapsed: 1.121 sec. Processed 8.87 million rows, 7.86 GB (7.92 million rows/s., 7.02 GB/s.) | |
| milovidov-desktop :) ALTER TABLE test.hits ADD COLUMN all String MATERIALIZED formatRow('TSV', WatchID, JavaEnable, Title, GoodEvent, EventTime, EventDate, CounterID, ClientIP, ClientIP6, RegionID, UserID, CounterClass, OS, UserAgent, URL, Referer, URLDomain, RefererDomain, Refresh, IsRobot, RefererCategories, URLCategories, URLRegions, RefererRegions, ResolutionWidth, ResolutionHeight, ResolutionDepth, FlashMajor, FlashMinor, FlashMinor2, NetMajor, NetMinor, UserAgentMajor, UserAgentMinor, CookieEnable, JavascriptEnable, IsMobile, MobilePhone, MobilePhoneModel, Params, IPNetworkID, TraficSourceID, SearchEngineID, SearchPhrase, AdvEngineID, IsArtifical, WindowClientWidth, WindowClientHeight, ClientTimeZone, ClientEventTime, SilverlightVersion1, SilverlightVersion2, SilverlightVersion3, SilverlightVersion4, PageCharset, CodeVersion, IsLink, IsDownload, IsNotBounce, FUniqID, HID, IsOldCounter, IsEvent, IsParameter, DontCountHits, WithHash, HitColor, UTCEventTime, Age, Sex, Income, Interests, Robotness, GeneralInterests, RemoteIP, RemoteIP6, WindowName, OpenerName, HistoryLength, BrowserLanguage, BrowserCountry, SocialNetwork, SocialAction, HTTPError, SendTiming, DNSTiming, ConnectTiming, ResponseStartTiming, ResponseEndTiming, FetchTiming, RedirectTiming, DOMInteractiveTiming, DOMContentLoadedTiming, DOMCompleteTiming, LoadEventStartTiming, LoadEventEndTiming, NSToDOMContentLoadedTiming, FirstPaintTiming, RedirectCount, SocialSourceNetworkID, SocialSourcePage, ParamPrice, ParamOrderID, ParamCurrency, ParamCurrencyID, GoalsReached, OpenstatServiceName, OpenstatCampaignID, OpenstatAdID, OpenstatSourceID, UTMSource, UTMMedium, UTMCampaign, UTMContent, UTMTemilovidov-desktop :) SELECT count() FROM test.hits WHERE formatRow('TSV', *) ILIKE '%xyz%' | |
| SELECT count() | |
| FROM test.hits | |
| WHERE formatRow('TSV', *) ILIKE '%xyz%' | |
| Query id: b07fb59f-e395-4608-89fb-11cb31ab40ca | |
| ββcount()ββ | |
| β 3725 β | |
| βββββββββββ | |
| 1 rows in set. Elapsed: 3.120 sec. Processed 8.87 million rows, 8.46 GB (2.84 million rows/s., 2.71 GB/s.) | |
| milovidov-desktop :) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment