kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kaine Yan <kaine....@gmail.com>
Subject JOIN ERROR
Date Tue, 24 Mar 2015 07:51:45 GMT
Hello , I sent this problem several days ago and have not solved it yet.

Here is the SQL

SELECT
FACT_TABLE.QKDYDM
FROM DEFAULT.ZSJ_FACT_YT as FACT_TABLE
LEFT JOIN DEFAULT.ZSJ_DIM_ORG as null
ON FACT_TABLE.QKDYDM = null.YTDM

I wonder why the lookup table's alias name is null . I selected default
settings and used Auto Generator to generate dimensions and error still
occured.

Here is the related json

{
  "uuid": "098e7255-5bb1-4830-a2be-bcfc22a44836",
  "name": "ZSJ",
  "description": "",
  "dimensions": [
    {
      "id": 1,
      "name": "DEFAULT.ZSJ_FACT_YT.QKDYDM",
      "table": "DEFAULT.ZSJ_FACT_YT",
      "column": [
        "QKDYDM"
      ],
      "derived": null,
      "hierarchy": false
    }
  ],
  "measures": [
    {
      "id": 1,
      "name": "_COUNT_",
      "function": {
        "expression": "COUNT",
        "parameter": {
          "type": "constant",
          "value": "1"
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    }
  ],
  "rowkey": {
    "rowkey_columns": [
      {
        "column": "QKDYDM",
        "length": 0,
        "dictionary": "true",
        "mandatory": false
      }
    ],
    "aggregation_groups": [
      [
        "QKDYDM"
      ]
    ]
  },
  "signature": "QHi8TYV6oXuxC6L0UWHnsA==",
  "last_modified": 1427165774865,
  "model_name": "ZSJ",
  "null_string": null,
  "hbase_mapping": {
    "column_family": [
      {
        "name": "F1",
        "columns": [
          {
            "qualifier": "M",
            "measure_refs": [
              "_COUNT_"
            ]
          }
        ]
      }
    ]
  },
  "notify_list": []
}

Could I be helped?

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message