You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Ravindra Pesala (JIRA)" <ji...@apache.org> on 2016/08/26 06:04:20 UTC
[jira] [Created] (CARBONDATA-181) Query result shows wrong
Ravindra Pesala created CARBONDATA-181:
------------------------------------------
Summary: Query result shows wrong
Key: CARBONDATA-181
URL: https://issues.apache.org/jira/browse/CARBONDATA-181
Project: CarbonData
Issue Type: Bug
Reporter: Ravindra Pesala
Following query result shows wrong in carbondata.
{code}
SELECT
*
FROM
( SELECT
ROW_NUMBER() over(
ORDER BY
SUBS_COUNT_ID DESC
) AS ROWID,
COUNT(1) over() AS DATACNT,
DEVICE_BRAND,
DEVICE_BRAND_EN,
CAST(SUBS_COUNT_ID AS DECIMAL(20)) AS SUBS_COUNT_ID,
CAST(SUBS_COUNT_TOTAL_ID AS DECIMAL(20,2)) AS PENETRATION_RATE_KPIID
FROM
( SELECT
SDR_FLOW_BASE_USER_1DAY.DEVICE_BRAND,
SDR_FLOW_BASE_USER_1DAY.DEVICE_BRAND_EN,
SUM(1) AS SUBS_COUNT_ID,
SUM(SUM(1)) over() AS SUBS_COUNT_TOTAL_ID
FROM
( SELECT
DIM_TERMINAL.DEVICE_BRAND AS DEVICE_BRAND,
DIM_TERMINAL.DEVICE_BRAND_EN AS DEVICE_BRAND_EN,
SDR_FLOW_BASE_USER_1DAY.SUBS_COUNT_ID AS SUBS_COUNT_ID,
SDR_FLOW_BASE_USER_1DAY.SUBS_COUNT_TOTAL_ID AS SUBS_COUNT_TOTAL_ID
FROM
( SELECT
MSISDN AS SUBS_COUNT_ID,
MSISDN AS SUBS_COUNT_TOTAL_ID,
SGSN_ID,
TAC
FROM
devload AS SDR_FLOW_BASE_USER_1DAY
WHERE
((STARTTIME >= 1
AND STARTTIME < 14598720000))
GROUP BY
SGSN_ID,
TAC,
MSISDN) AS SDR_FLOW_BASE_USER_1DAY
LEFT OUTER JOIN(SELECT
DIM_LOC_SGSN.SGSN_ID AS SGSN_SGSN,
DIM_LOC_SGSN.SGSN_NAME AS SGSN_SGSN_EN,
DIM_LOC_SGSN.SGSN_ID AS NE_ID
FROM
( SELECT
*,
-9999 AS DUMMY_ID
FROM
DIM_LOC_SGSN) AS DIM_LOC_SGSN) AS DIM_LOC_SGSN
ON(((DIM_LOC_SGSN.NE_ID = SDR_FLOW_BASE_USER_1DAY.SGSN_ID
)))
LEFT OUTER JOIN(SELECT
DIM_TERMINAL.TER_BRAND_NAME AS DEVICE_BRAND,
DIM_TERMINAL.TER_BRAND_NAME AS DEVICE_BRAND_EN,
DIM_TERMINAL.TAC AS BRAND
FROM
DIM_TERMINAL AS DIM_TERMINAL) AS DIM_TERMINAL
ON(((DIM_TERMINAL.BRAND = SDR_FLOW_BASE_USER_1DAY.TAC
)))
GROUP BY
SDR_FLOW_BASE_USER_1DAY.SUBS_COUNT_ID,
SDR_FLOW_BASE_USER_1DAY.SUBS_COUNT_TOTAL_ID,
DEVICE_BRAND,
DEVICE_BRAND_EN,
TAC) AS SDR_FLOW_BASE_USER_1DAY
GROUP BY
DEVICE_BRAND,
DEVICE_BRAND_EN) AS SDR_FLOW_BASE_USER_1DAY) AS SDR_FLOW_BASE_USER_1DAY
WHERE
ROWID > 0
AND ROWID < 10
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)