CreateQuery fct_rt_dc_shop_sku_vender_day (children 3)
 Identifier fct_rt_dc_shop_sku_vender_day
 Columns definition (children 1)
  ExpressionList (children 61)
   ColumnDeclaration stat_year (children 1)
    DataType UInt16
   ColumnDeclaration stat_month (children 1)
    DataType UInt32
   ColumnDeclaration stat_day (children 1)
    DataType Date
   ColumnDeclaration out_buid (children 1)
    DataType UInt8
   ColumnDeclaration out_shop_id (children 1)
    DataType String
   ColumnDeclaration in_shop_id (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration datasource (children 1)
    DataType UInt8
   ColumnDeclaration venderid (children 1)
    DataType String
   ColumnDeclaration categorytreeid (children 1)
    DataType UInt8
   ColumnDeclaration categoryid (children 1)
    DataType String
   ColumnDeclaration goodsid (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration logistics (children 1)
    DataType UInt8
   ColumnDeclaration buntype (children 1)
    DataType UInt8
   ColumnDeclaration dctype (children 1)
    DataType UInt8
   ColumnDeclaration shopformid (children 1)
    DataType UInt8
   ColumnDeclaration rt_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_taxcost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_shops (children 1)
    DataType Nullable (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration rt_drygood_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_fresh_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_supshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_supshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_supshop_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_supshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_smallshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_smallshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_smallshop_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_smallshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_dc_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_dc_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_dc_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_dc_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_drygood_supshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_supshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_supshop_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_supshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_drygood_smallshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_smallshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_smallshop_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_smallshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_drygood_dc_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_dc_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_dc_boxes (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_drygood_dc_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_fresh_supshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_supshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_supshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_fresh_smallshop_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_smallshop_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_smallshop_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration rt_fresh_dc_cost (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_dc_qty (children 1)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_18
      Literal UInt64_4
   ColumnDeclaration rt_fresh_dc_shops (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType Nullable (children 1)
       ExpressionList (children 1)
        DataType String
   ColumnDeclaration stat_day_num (children 2)
    DataType String
    Function formatDateTime (children 1)
     ExpressionList (children 2)
      Identifier stat_day
      Literal \'%F\'
 Storage definition (children 4)
  Function MergeTree
  Function toYYYYMM (children 1)
   ExpressionList (children 1)
    Identifier stat_day
  Function tuple (children 1)
   ExpressionList (children 2)
    Identifier stat_day
    Identifier out_shop_id
  Set
