extensions/spark/kyuubi-spark-connector-tpcds/src/main/resources/kyuubi/tpcds_3.2/q53.sql [26:76]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
        from
            item,
            store_sales,
            date_dim,
            store
        where
            ss_item_sk = i_item_sk
            and ss_sold_date_sk = d_date_sk
            and ss_store_sk = s_store_sk
            and d_month_seq in (
                1212,
                1212 + 1,
                1212 + 2,
                1212 + 3,
                1212 + 4,
                1212 + 5,
                1212 + 6,
                1212 + 7,
                1212 + 8,
                1212 + 9,
                1212 + 10,
                1212 + 11
            )
            and (
                (
                    i_category in ('Books', 'Children', 'Electronics')
                    and i_class in ('personal', 'portable', 'reference', 'self-help')
                    and i_brand in (
                        'scholaramalgamalg #14',
                        'scholaramalgamalg #7',
                        'exportiunivamalg #9',
                        'scholaramalgamalg #9'
                    )
                )
                or (
                    i_category in ('Women', 'Music', 'Men')
                    and i_class in (
                        'accessories',
                        'classical',
                        'fragrances',
                        'pants'
                    )
                    and i_brand in (
                        'amalgimporto #1',
                        'edu packscholar #1',
                        'exportiimporto #1',
                        'importoamalg #1'
                    )
                )
            )
        group by
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



extensions/spark/kyuubi-spark-connector-tpcds/src/main/resources/kyuubi/tpcds_3.2/q63.sql [26:76]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    from
      item,
      store_sales,
      date_dim,
      store
    where
      ss_item_sk = i_item_sk
      and ss_sold_date_sk = d_date_sk
      and ss_store_sk = s_store_sk
      and d_month_seq in (
        1212,
        1212 + 1,
        1212 + 2,
        1212 + 3,
        1212 + 4,
        1212 + 5,
        1212 + 6,
        1212 + 7,
        1212 + 8,
        1212 + 9,
        1212 + 10,
        1212 + 11
      )
      and (
        (
          i_category in ('Books', 'Children', 'Electronics')
          and i_class in ('personal', 'portable', 'reference', 'self-help')
          and i_brand in (
            'scholaramalgamalg #14',
            'scholaramalgamalg #7',
            'exportiunivamalg #9',
            'scholaramalgamalg #9'
          )
        )
        or (
          i_category in ('Women', 'Music', 'Men')
          and i_class in (
            'accessories',
            'classical',
            'fragrances',
            'pants'
          )
          and i_brand in (
            'amalgimporto #1',
            'edu packscholar #1',
            'exportiimporto #1',
            'importoamalg #1'
          )
        )
      )
    group by
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



