ERROR: SQL-MR function DISTNMATCHMULTIPLEINPUT failed

Analytics

ERROR: SQL-MR function DISTNMATCHMULTIPLEINPUT failed

Hi guys,

I am using Distribution Matching in statistical analysis function. 

 

Here, is the snippet code:

SELECT * FROM DistnmatchReduce (
	ON DistnmatchMultipleInput (
		ON (SELECT COUNT (1) AS counts,
			SUM (COUNT (1)) OVER (PARTITION BY column1 ORDER BY column1) AS rank, column1
			FROM table1
			WHERE column1 IS NOT NULL
			GROUP BY column1
		) AS input PARTITION BY column1
		ORDER BY column1
		ON (SELECT column1, COUNT(*) AS group_size
			FROM table1
			WHERE column1 IS NOT NULL
			GROUP BY column1
		) AS groupstats DIMENSION
		ValueColumn ('column1')
		Distributions ('NORMAL:4.84,0.41')
	) PARTITION BY 1
);

 

When run the above function, I get the following error:

 

Executed as Single statement. Failed [34 : HY000] [AsterData][ASTERJDBCDSII](34) ERROR: SQL-MR function DISTNMATCHMULTIPLEINPUT failed: In 'match' mode, missing one of the following columns: 'mean', 'sd', 'maximum' or 'minimum' column in the 'groupstats' table. ()

 

Can someone help me. Thank you in advance.