correct scheme

canondata

3 files changed, 55 insertions, 55 deletions

diff --git a/ydb/public/lib/ydb_cli/commands/click_bench_schema.sql b/ydb/public/lib/ydb_cli/commands/click_bench_schema.sql
index 9590580527..5becd12b40 100644
--- a/ydb/public/lib/ydb_cli/commands/click_bench_schema.sql
+++ b/ydb/public/lib/ydb_cli/commands/click_bench_schema.sql
@@ -2,96 +2,96 @@
 CREATE TABLE `{table}`
 (
     WatchID Int64 {notnull},
-    JavaEnable Int32 {notnull},
+    JavaEnable Int16 {notnull},
     Title Text {notnull},
-    GoodEvent Int32 {notnull},
+    GoodEvent Int16 {notnull},
     EventTime Timestamp {notnull},
-    EventDate Timestamp {notnull},
+    EventDate Date {notnull},
     CounterID Int32 {notnull},
     ClientIP Int32 {notnull},
     RegionID Int32 {notnull},
     UserID Int64 {notnull},
-    CounterClass Int32 {notnull},
-    OS Int32 {notnull},
-    UserAgent Int32 {notnull},
+    CounterClass Int16 {notnull},
+    OS Int16 {notnull},
+    UserAgent Int16 {notnull},
     URL Text {notnull},
     Referer Text {notnull},
-    IsRefresh Int32 {notnull},
-    RefererCategoryID Int32 {notnull},
+    IsRefresh Int16 {notnull},
+    RefererCategoryID Int16 {notnull},
     RefererRegionID Int32 {notnull},
-    URLCategoryID Int32 {notnull},
+    URLCategoryID Int16 {notnull},
     URLRegionID Int32 {notnull},
-    ResolutionWidth Int32 {notnull},
-    ResolutionHeight Int32 {notnull},
-    ResolutionDepth Int32 {notnull},
-    FlashMajor Int32 {notnull},
-    FlashMinor Int32 {notnull},
+    ResolutionWidth Int16 {notnull},
+    ResolutionHeight Int16 {notnull},
+    ResolutionDepth Int16 {notnull},
+    FlashMajor Int16 {notnull},
+    FlashMinor Int16 {notnull},
     FlashMinor2 Text {notnull},
-    NetMajor Int32 {notnull},
-    NetMinor Int32 {notnull},
-    UserAgentMajor Int32 {notnull},
+    NetMajor Int16 {notnull},
+    NetMinor Int16 {notnull},
+    UserAgentMajor Int16 {notnull},
     UserAgentMinor Bytes {notnull},
-    CookieEnable Int32 {notnull},
-    JavascriptEnable Int32 {notnull},
-    IsMobile Int32 {notnull},
-    MobilePhone Int32 {notnull},
+    CookieEnable Int16 {notnull},
+    JavascriptEnable Int16 {notnull},
+    IsMobile Int16 {notnull},
+    MobilePhone Int16 {notnull},
     MobilePhoneModel Text {notnull},
     Params Text {notnull},
     IPNetworkID Int32 {notnull},
-    TraficSourceID Int32 {notnull},
-    SearchEngineID Int32 {notnull},
+    TraficSourceID Int16 {notnull},
+    SearchEngineID Int16 {notnull},
     SearchPhrase Text {notnull},
-    AdvEngineID Int32 {notnull},
-    IsArtifical Int32 {notnull},
-    WindowClientWidth Int32 {notnull},
-    WindowClientHeight Int32 {notnull},
-    ClientTimeZone Int32 {notnull},
+    AdvEngineID Int16 {notnull},
+    IsArtifical Int16 {notnull},
+    WindowClientWidth Int16 {notnull},
+    WindowClientHeight Int16 {notnull},
+    ClientTimeZone Int16 {notnull},
     ClientEventTime Timestamp {notnull},
-    SilverlightVersion1 Int32 {notnull},
-    SilverlightVersion2 Int32 {notnull},
+    SilverlightVersion1 Int16 {notnull},
+    SilverlightVersion2 Int16 {notnull},
     SilverlightVersion3 Int32 {notnull},
-    SilverlightVersion4 Int32 {notnull},
+    SilverlightVersion4 Int16 {notnull},
     PageCharset Text {notnull},
     CodeVersion Int32 {notnull},
-    IsLink Int32 {notnull},
-    IsDownload Int32 {notnull},
-    IsNotBounce Int32 {notnull},
+    IsLink Int16 {notnull},
+    IsDownload Int16 {notnull},
+    IsNotBounce Int16 {notnull},
     FUniqID Int64 {notnull},
     OriginalURL Text {notnull},
     HID Int32 {notnull},
-    IsOldCounter Int32 {notnull},
-    IsEvent Int32 {notnull},
-    IsParameter Int32 {notnull},
-    DontCountHits Int32 {notnull},
-    WithHash Int32 {notnull},
-    HitColor Bytes {notnull},
+    IsOldCounter Int16 {notnull},
+    IsEvent Int16 {notnull},
+    IsParameter Int16 {notnull},
+    DontCountHits Int16 {notnull},
+    WithHash Int16 {notnull},
+    HitColor Text {notnull},
     LocalEventTime Timestamp {notnull},
-    Age Int32 {notnull},
-    Sex Int32 {notnull},
-    Income Int32 {notnull},
-    Interests Int32 {notnull},
-    Robotness Int32 {notnull},
+    Age Int16 {notnull},
+    Sex Int16 {notnull},
+    Income Int16 {notnull},
+    Interests Int16 {notnull},
+    Robotness Int16 {notnull},
     RemoteIP Int32 {notnull},
     WindowName Int32 {notnull},
     OpenerName Int32 {notnull},
-    HistoryLength Int32 {notnull},
+    HistoryLength Int16 {notnull},
     BrowserLanguage Text {notnull},
     BrowserCountry Text {notnull},
     SocialNetwork Text {notnull},
     SocialAction Text {notnull},
-    HTTPError Int32 {notnull},
+    HTTPError Int16 {notnull},
     SendTiming Int32 {notnull},
     DNSTiming Int32 {notnull},
     ConnectTiming Int32 {notnull},
     ResponseStartTiming Int32 {notnull},
     ResponseEndTiming Int32 {notnull},
     FetchTiming Int32 {notnull},
-    SocialSourceNetworkID Int32 {notnull},
+    SocialSourceNetworkID Int16 {notnull},
     SocialSourcePage Text {notnull},
     ParamPrice Int64 {notnull},
     ParamOrderID Text {notnull},
     ParamCurrency Text {notnull},
-    ParamCurrencyID Int32 {notnull},
+    ParamCurrencyID Int16 {notnull},
     OpenstatServiceName Text {notnull},
     OpenstatCampaignID Text {notnull},
     OpenstatAdID Text {notnull},
@@ -102,11 +102,11 @@ CREATE TABLE `{table}`
     UTMContent Text {notnull},
     UTMTerm Text {notnull},
     FromTag Text {notnull},
-    HasGCLID Int32 {notnull},
+    HasGCLID Int16 {notnull},
     RefererHash Int64 {notnull},
     URLHash Int64 {notnull},
     CLID Int32 {notnull},
-    --PRIMARY KEY (CounterID, EventDate, UserID, EventTime, WatchID)
+
     PRIMARY KEY (EventTime, CounterID, EventDate, UserID, WatchID)
 )
 {partition}
diff --git a/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_column_/queries-deterministic-results-6 b/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_column_/queries-deterministic-results-6
index b3a9f5fb03..8c2373653d 100644
--- a/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_column_/queries-deterministic-results-6
+++ b/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_column_/queries-deterministic-results-6
@@ -1,6 +1,6 @@
 [
     {
-        "column0": 1373846400000000,
-        "column1": 1373846400000000
+        "column0": 15901,
+        "column1": 15901
     }
 ]
\ No newline at end of file
diff --git a/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_row_/queries-deterministic-results-6 b/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_row_/queries-deterministic-results-6
index b3a9f5fb03..8c2373653d 100644
--- a/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_row_/queries-deterministic-results-6
+++ b/ydb/tests/functional/clickbench/canondata/test.test_run_determentistic_row_/queries-deterministic-results-6
@@ -1,6 +1,6 @@
 [
     {
-        "column0": 1373846400000000,
-        "column1": 1373846400000000
+        "column0": 15901,
+        "column1": 15901
     }
 ]
\ No newline at end of file