create TRANSIENT TABLE SUNO_PROD.PROD.ML_SONG_SUMMARY_INFO_V1 (
	ID NUMBER(38,0),
	SONG_ID VARCHAR(255),
	P_DATE VARCHAR(255),
	P_HOUR VARCHAR(255),
	TOTAL_PLAY_COUNT NUMBER(38,0),
	AUTO_PLAY_COUNT NUMBER(38,0),
	TOTAL_PLAY_TIME FLOAT,
	TOTAL_PLAY_COUNT_HOUR NUMBER(38,0),
	AUTO_PLAY_COUNT_HOUR NUMBER(38,0),
	TOTAL_PLAY_TIME_HOUR FLOAT,
	WEB_TOTAL_PLAY_CNT_0 NUMBER(38,0),
	WEB_TOTAL_PLAY_DURATION_0 FLOAT,
	WEB_TOTAL_PLAY_CNT_5 NUMBER(38,0),
	WEB_TOTAL_PLAY_DURATION_5 FLOAT,
	WEB_NON_CREATOR_LISTEN_DURATION_0 FLOAT,
	WEB_NON_CREATOR_LISTEN_DURATION_5 FLOAT,
	IOS_TOTAL_PLAY_CNT_0 NUMBER(38,0),
	IOS_TOTAL_PLAY_DURATION_0 FLOAT,
	IOS_TOTAL_PLAY_CNT_5 NUMBER(38,0),
	IOS_TOTAL_PLAY_DURATION_5 FLOAT,
	IOS_NON_CREATOR_LISTEN_DURATION_0 FLOAT,
	IOS_NON_CREATOR_LISTEN_DURATION_5 FLOAT,
	ANDROID_TOTAL_PLAY_CNT_0 NUMBER(38,0),
	ANDROID_TOTAL_PLAY_DURATION_0 FLOAT,
	ANDROID_TOTAL_PLAY_CNT_5 NUMBER(38,0),
	ANDROID_TOTAL_PLAY_DURATION_5 FLOAT,
	ANDROID_NON_CREATOR_LISTEN_DURATION_0 FLOAT,
	ANDROID_NON_CREATOR_LISTEN_DURATION_5 FLOAT,
	SUM_TOTAL_PLAY_CNT_0 NUMBER(38,0),
	SUM_TOTAL_PLAY_DURATION_0 FLOAT,
	SUM_TOTAL_PLAY_CNT_5 NUMBER(38,0),
	SUM_TOTAL_PLAY_DURATION_5 FLOAT,
	SUM_NON_CREATOR_LISTEN_DURATION_0 FLOAT,
	SUM_NON_CREATOR_LISTEN_DURATION_5 FLOAT
) cluster by (p_date, song_id) ;
