You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Kaine Yan <ka...@gmail.com> on 2015/03/24 08:51:45 UTC
JOIN ERROR
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?
Re: JOIN ERROR
Posted by "Shi, Shaofeng" <sh...@ebay.com>.
Thanks Luke; @Kaine, please get the latest build and retry the cube
building; just let us know if still have the problem;
https://kylin.incubator.apache.org/download/
On 3/25/15, 9:20 AM, "Luke Han" <lu...@gmail.com> wrote:
>The package already be updated with latest fix.
>
>Thanks.
>
>
>Best Regards!
>---------------------
>
>Luke Han
>
>2015-03-24 17:58 GMT-07:00 Shi, Shaofeng <sh...@ebay.com>:
>
>> This problem has already been fixed in last week, the original JIRA is:
>> https://issues.apache.org/jira/browse/KYLIN-644
>>
>> @Luke, from the commit number on download page, it seems the current
>> binary package doesn¹t include this fix; Could you upload a new one?
>>
>>
>> On 3/24/15, 11:53 PM, "Luke Han" <lu...@gmail.com> wrote:
>>
>> >What's exactly issue you have? Can't build cube or can't query result?
>> >Could you please share more details for further analysis?
>> >
>> >For null value of alias name, please refer to this JIRA for tracking:
>> >https://issues.apache.org/jira/browse/KYLIN-652
>> >
>> >Thanks.
>> >
>> >
>> >Best Regards!
>> >---------------------
>> >
>> >Luke Han
>> >
>> >2015-03-24 0:51 GMT-07:00 Kaine Yan <ka...@gmail.com>:
>> >
>> >> 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?
>> >>
>>
>>
Re: JOIN ERROR
Posted by Luke Han <lu...@gmail.com>.
The package already be updated with latest fix.
Thanks.
Best Regards!
---------------------
Luke Han
2015-03-24 17:58 GMT-07:00 Shi, Shaofeng <sh...@ebay.com>:
> This problem has already been fixed in last week, the original JIRA is:
> https://issues.apache.org/jira/browse/KYLIN-644
>
> @Luke, from the commit number on download page, it seems the current
> binary package doesn¹t include this fix; Could you upload a new one?
>
>
> On 3/24/15, 11:53 PM, "Luke Han" <lu...@gmail.com> wrote:
>
> >What's exactly issue you have? Can't build cube or can't query result?
> >Could you please share more details for further analysis?
> >
> >For null value of alias name, please refer to this JIRA for tracking:
> >https://issues.apache.org/jira/browse/KYLIN-652
> >
> >Thanks.
> >
> >
> >Best Regards!
> >---------------------
> >
> >Luke Han
> >
> >2015-03-24 0:51 GMT-07:00 Kaine Yan <ka...@gmail.com>:
> >
> >> 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?
> >>
>
>
Re: JOIN ERROR
Posted by "Shi, Shaofeng" <sh...@ebay.com>.
This problem has already been fixed in last week, the original JIRA is:
https://issues.apache.org/jira/browse/KYLIN-644
@Luke, from the commit number on download page, it seems the current
binary package doesn¹t include this fix; Could you upload a new one?
On 3/24/15, 11:53 PM, "Luke Han" <lu...@gmail.com> wrote:
>What's exactly issue you have? Can't build cube or can't query result?
>Could you please share more details for further analysis?
>
>For null value of alias name, please refer to this JIRA for tracking:
>https://issues.apache.org/jira/browse/KYLIN-652
>
>Thanks.
>
>
>Best Regards!
>---------------------
>
>Luke Han
>
>2015-03-24 0:51 GMT-07:00 Kaine Yan <ka...@gmail.com>:
>
>> 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?
>>
Re: JOIN ERROR
Posted by Luke Han <lu...@gmail.com>.
What's exactly issue you have? Can't build cube or can't query result?
Could you please share more details for further analysis?
For null value of alias name, please refer to this JIRA for tracking:
https://issues.apache.org/jira/browse/KYLIN-652
Thanks.
Best Regards!
---------------------
Luke Han
2015-03-24 0:51 GMT-07:00 Kaine Yan <ka...@gmail.com>:
> 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?
>