You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "xavierzhao (via GitHub)" <gi...@apache.org> on 2023/06/25 01:30:25 UTC

[GitHub] [doris] xavierzhao opened a new issue, #21117: Do you have any plans to release a new version of 1.x or a stable version of 2.0 in the future and fix this issue?

xavierzhao opened a new issue, #21117:
URL: https://github.com/apache/doris/issues/21117

   Recently I upgraded version to Doris from version 1.2.1  to version 1.2.4-1.
   
   The problem is when I execute unit test it dosen't working, it's look like there is a change in the version that cause this problem.
   
   Here is exception message:
   
   ![image](https://github.com/apache/doris/assets/1573662/f956a439-ad20-4582-bf38-a336acc3af7a)
   
   and SQL like this:
   `
   SELECT
   	totalNum - lag ( totalNum,
   	1,
   	0 ) over (
   ORDER BY
   	sortNum ) AS totalNum
   FROM
   	(
   	SELECT
   		sortNum,
   		BITMAP_UNION_COUNT (pv) over (
   	ORDER BY
   		sortNum ) totalNum
   	FROM
   		(
   		SELECT
   			ifnull( a.sortNum, b.sortNum ) sortNum,
   			BITMAP_UNION ( ifnull( a.pv, b.pv ) ) pv
   		FROM
   			(
   			SELECT
   				1 sortNum,
   				BITMAP_UNION (DEVICE_ID) AS pv
   			FROM
   				APP_LOG
   			WHERE
   				LOG_DATE >= '2023-06-01'
   				AND LOG_DATE <= '2023-06-30'
   			ORDER BY
   				sortNum ) a
   		FULL JOIN (
   			SELECT
   				'2' sortNum,
   				BITMAP_UNION (DEVICE_ID) AS pv
   			FROM
   				APP_LOG
   			WHERE
   				LOG_DATE < '2023-06-01'
   			ORDER BY
   				sortNum ) b ON
   			a.sortNum = b.sortNum
   		GROUP BY
   			sortNum
   		ORDER BY
   			sortNum 
   		) c 
   	) final
   LIMIT 1
   `
   
   Any idea.?
   
   
   
   _Originally posted by @xavierzhao in https://github.com/apache/doris/discussions/21017_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] xavierzhao closed issue #21117: Do you have any plans to release a new version of 1.x or a stable version of 2.0 in the future and fix this issue?

Posted by "xavierzhao (via GitHub)" <gi...@apache.org>.
xavierzhao closed issue #21117: Do you have any plans to release a new version of 1.x or a stable version of 2.0 in the future and fix this issue? 
URL: https://github.com/apache/doris/issues/21117


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org