regression-test/data/rollup_p0/test_materialized_view.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !sql --
test_materialized_view1	DUP_KEYS	record_id	int	int	Yes	true	\N		true		
		seller_id	int	int	Yes	true	\N		true		
		store_id	int	int	Yes	true	\N		true		
		sale_date	date	datev2	Yes	false	\N	NONE	true		
		sale_amt	bigint	bigint	Yes	false	\N	NONE	true		
											
amt_sum	AGG_KEYS	a1	int	int	Yes	true	\N		true	`store_id`	
		a2	bigint	bigint	Yes	false	\N	SUM	true	`sale_amt`	

-- !sql --
test_materialized_view2	DUP_KEYS	record_id	int	int	Yes	true	\N		true		
		seller_id	int	int	Yes	true	\N		true		
		store_id	int	int	Yes	true	\N		true		
		sale_date	date	datev2	Yes	false	\N	NONE	true		
		sale_amt	bigint	bigint	Yes	false	\N	NONE	true		
											
seller_id_order	DUP_KEYS	a3	int	int	Yes	true	\N		true	`store_id`	
		a4	int	int	Yes	true	\N		true	`seller_id`	
		a5	bigint	bigint	Yes	false	\N	NONE	true	`sale_amt`	

-- !sql --
1	1	1	2020-05-30	100
2	1	1	2020-05-30	100

-- !sql --
1	200

-- !sql --
1	1	1	2020-05-30	100
2	1	1	2020-05-30	100

-- !sql --
1	200

-- !sql --
											
											
		a2	bigint	bigint	Yes	false	\N	SUM	true	`sale_amt`	
		a7	bigint	bigint	No	false	\N	SUM	true	CASE WHEN `sale_amt` IS NULL THEN 0 ELSE 1 END	
		sale_amt	bigint	bigint	Yes	false	\N	NONE	true		
		sale_date	date	datev2	Yes	false	\N	NONE	true		
		seller_id	int	int	Yes	true	\N		true		
		store_id	int	int	Yes	true	\N		true		
amt_count	AGG_KEYS	a6	int	int	Yes	true	\N		true	`store_id`	
amt_sum	AGG_KEYS	a1	int	int	Yes	true	\N		true	`store_id`	
test_materialized_view1	DUP_KEYS	record_id	int	int	Yes	true	\N		true		

-- !sql --
1	2