Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3389

intersect_count error

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: v2.2.0
    • Fix Version/s: Future
    • Labels:
    • Environment:
      hive+kylin+hbase

      Description

      select
      city_name,
      intersect_count(server_user, dt,array['2018-05-10'] ) aaa
      from
      table
      where dt>='2018-05-10'
      group by city_name

       return: Error while compiling statement: FAILED: SemanticException [Error 10025]: Line 3:0 Expression not in GROUP BY key ''2018-05-10''

       

       

       

      here is cube json:

      {
      "uuid": "5fe19005-7b31-4225-b7b3-62fde2c72256",
      "last_modified": 1527489049614,
      "version": "2.2.0.0",
      "name": "CUBE_RETENTION_RD_LQ",
      "owner": "SY_DW_U_RD",
      "descriptor": "CUBE_RETENTION_RD_LQ",
      "cost": 50,
      "status": "READY",
      "segments": [
      {
      "uuid": "75336a8d-a7b6-4465-bb63-fc3ff59b379e",
      "name": "20180301000000_20180528000000",
      "storage_location_identifier": "KYLIN_JVERXYS4CG",
      "date_range_start": 1519862400000,
      "date_range_end": 1527465600000,
      "source_offset_start": 0,
      "source_offset_end": 0,
      "status": "READY",
      "size_kb": 99,
      "input_records": 7534006,
      "input_records_size": 136364517,
      "last_build_time": 1527489049614,
      "last_build_job_id": "729f584e-66aa-46e3-a5b5-837aef69253c",
      "create_time_utc": 1527488801260,
      "cuboid_shard_nums": {},
      "total_shards": 1,
      "blackout_cuboids": [],
      "binary_signature": null,
      "dictionaries":

      { "M_ORDER_DETAIL.CITY_NAME": "/dict/SY_MART_KYLIN.M_ORDER_DETAIL/CITY_NAME/e7373276-ee9a-4308-93cf-ba5f3fafcf23.dict", "M_ORDER_DETAIL.DT": "/dict/SY_MART_KYLIN.M_ORDER_DETAIL/DT/29ec1575-8497-4df2-bb51-dcb9e7dda1a1.dict" }

      ,
      "snapshots": null,
      "rowkey_stats": [
      [
      "M_ORDER_DETAIL.CITY_NAME",
      336,
      2
      ],
      [
      "M_ORDER_DETAIL.DT",
      57,
      1
      ]
      ]
      }
      ],
      "create_time_utc": 1527488778311,
      "cuboid_bytes": null,
      "cuboid_bytes_recommend": null,
      "cuboid_last_optimized": 0,
      "size_kb": 99,
      "input_records_count": 7534006,
      "input_records_size": 136364517
      }

       

       

      what's the problem?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alexanike QingLi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 168h
                168h
                Remaining:
                Remaining Estimate - 168h
                168h
                Logged:
                Time Spent - Not Specified
                Not Specified