Smartbi Mining - Details for Query 394

Submitted Time: 2025/06/26 08:00:07
Duration: 19 ms
Succeeded Jobs: 396

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label="InMemoryTableScan number of output rows: 6,840"]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 3 [labelType="html" label=" SerializeFromObject "]; 4 [labelType="html" label=" MapElements "]; 5 [labelType="html" label=" DeserializeToObject "]; } 6 [labelType="html" label="Generate number of output rows: 0"]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; 8 [labelType="html" label=" SerializeFromObject "]; 9 [labelType="html" label=" MapElements "]; 10 [labelType="html" label=" DeserializeToObject "]; 11 [labelType="html" label="Scan JDBCRelation(( SELECT \r \tDISTINCT t1.F0000080,\r \tcase when t4.ye<>''\r \tTHEN t4.ye\r \tELSE DATE_FORMAT(NOW(),'%Y') end ye\r \t,\r \t'01-02-03-04-05-06-07-08-09-10-11-12' dataTime\r \tfrom (SELECT F0000080 from `\u7ACB\u9879\u5BA1\u6279` WHERE `Status`='1' ) t1\r \tLEFT JOIN `\u4E95\u4F4D\u4FE1\u606F` t2 on t2.ObjectId=t1.F0000080 and t2.`Status`='1'\r \tLEFT JOIN `\u4E95\u4F4D\u8FD0\u884C\u60C5\u51B5\u8868` t3 on t2.ObjectId=t3.F0000026 and t3.`Status`='1'\r \tLEFT JOIN(\t\r \tSELECT DISTINCT F0000031,\r \tCASE WHEN date_format(F0000030, '%d')>25 and date_format(F0000030, '%c')=12\r \t\tTHEN date_format(F0000030, '%Y')+1\r \t\tELSE date_format(F0000030, '%Y')\r \t\tEND ye\r \t FROM \t`\u65E5\u62A5\u586B\u62A5` \r \t where Status='1' \r \t )t4 on t4.F0000031=t3.ObjectId ) as T) [numPartitions=1] number of output rows: 0"]; } 1->0; 3->1; 4->3; 5->4; 6->5; 8->6; 9->8; 10->9; 11->10; }

CollectLimit 100

InMemoryTableScan [F0000080#22678, ye#22679, dataTime#22680, monname#22681, mon#22682]

MapElements smartbix.datamining.engine.execute.node.preprocess.ValueReplaceNode$2@4e4f6351, obj#22677: org.apache.spark.sql.Row

DeserializeToObject createexternalrow(F0000080#22597.toString, ye#22598.toString, dataTime#22599.toString, monname#22648.toString, mon#22649.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true), StructField(monname,StringType,true), StructField(mon,StringType,true)), obj#22676: org.apache.spark.sql.Row

WholeStageCodegen (2)

Generate stack(12, dataTime_0, dataTime_0#22600, dataTime_1, dataTime_1#22601, dataTime_2, dataTime_2#22602, dataTime_3, dataTime_3#22603, dataTime_4, dataTime_4#22604, dataTime_5, dataTime_5#22605, dataTime_6, dataTime_6#22606, dataTime_7, dataTime_7#22607, dataTime_8, dataTime_8#22608, dataTime_9, dataTime_9#22609, dataTime_10, dataTime_10#22610, dataTime_11, dataTime_11#22611), [F0000080#22597, ye#22598, dataTime#22599], false, [monname#22648, mon#22649]

SerializeFromObject [if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 0, F0000080), StringType), true, false) AS F0000080#22597, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 1, ye), StringType), true, false) AS ye#22598, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 2, dataTime), StringType), true, false) AS dataTime#22599, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 3, dataTime_0), StringType), true, false) AS dataTime_0#22600, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 4, dataTime_1), StringType), true, false) AS dataTime_1#22601, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 5, dataTime_2), StringType), true, false) AS dataTime_2#22602, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 6, dataTime_3), StringType), true, false) AS dataTime_3#22603, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 7, dataTime_4), StringType), true, false) AS dataTime_4#22604, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 8, dataTime_5), StringType), true, false) AS dataTime_5#22605, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 9, dataTime_6), StringType), true, false) AS dataTime_6#22606, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 10, dataTime_7), StringType), true, false) AS dataTime_7#22607, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 11, dataTime_8), StringType), true, false) AS dataTime_8#22608, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 12, dataTime_9), StringType), true, false) AS dataTime_9#22609, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 13, dataTime_10), StringType), true, false) AS dataTime_10#22610, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 14, dataTime_11), StringType), true, false) AS dataTime_11#22611]

MapElements smartbix.datamining.engine.execute.node.preprocess.DivideNode$2@6a379505, obj#22596: org.apache.spark.sql.Row

DeserializeToObject createexternalrow(F0000080#22477.toString, ye#22478.toString, dataTime#22479.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true)), obj#22595: org.apache.spark.sql.Row

Scan JDBCRelation(( SELECT DISTINCT t1.F0000080, case when t4.ye<>'' THEN t4.ye ELSE DATE_FORMAT(NOW(),'%Y') end ye , '01-02-03-04-05-06-07-08-09-10-11-12' dataTime from (SELECT F0000080 from `立项审批` WHERE `Status`='1' ) t1 LEFT JOIN `井位信息` t2 on t2.ObjectId=t1.F0000080 and t2.`Status`='1' LEFT JOIN `井位运行情况表` t3 on t2.ObjectId=t3.F0000026 and t3.`Status`='1' LEFT JOIN( SELECT DISTINCT F0000031, CASE WHEN date_format(F0000030, '%d')>25 and date_format(F0000030, '%c')=12 THEN date_format(F0000030, '%Y')+1 ELSE date_format(F0000030, '%Y') END ye FROM `日报填报` where Status='1' )t4 on t4.F0000031=t3.ObjectId ) as T) [numPartitions=1] [F0000080#22477,ye#22478,dataTime#22479] PushedFilters: [], ReadSchema: struct<F0000080:string,ye:string,dataTime:string>

WholeStageCodegen (1)

Details

== Physical Plan ==
CollectLimit (2)
+- InMemoryTableScan (1)
      +- InMemoryRelation (2)
            +- * SerializeFromObject (10)
               +- * MapElements (9)
                  +- * DeserializeToObject (8)
                     +- Generate (7)
                        +- * SerializeFromObject (6)
                           +- * MapElements (5)
                              +- * DeserializeToObject (4)
                                 +- * Scan JDBCRelation(( SELECT 
	DISTINCT t1.F0000080,
	case when t4.ye<>''
	THEN t4.ye
	ELSE DATE_FORMAT(NOW(),'%Y') end  ye
	,
	'01-02-03-04-05-06-07-08-09-10-11-12' dataTime
	from (SELECT F0000080 from `立项审批` WHERE  `Status`='1' ) t1
	LEFT JOIN `井位信息` t2 on t2.ObjectId=t1.F0000080  and t2.`Status`='1'
	LEFT JOIN `井位运行情况表` t3 on t2.ObjectId=t3.F0000026 and t3.`Status`='1'
	LEFT JOIN(	
	SELECT DISTINCT F0000031,
	CASE  WHEN date_format(F0000030, '%d')>25  and date_format(F0000030, '%c')=12
		THEN date_format(F0000030, '%Y')+1
		ELSE date_format(F0000030, '%Y')
		END ye
	 FROM 	`日报填报` 
	 where Status='1' 
	 )t4 on t4.F0000031=t3.ObjectId 
 ) as T) [numPartitions=1]  (3)


(1) InMemoryTableScan
Output [5]: [F0000080#22678, ye#22679, dataTime#22680, monname#22681, mon#22682]
Arguments: [F0000080#22678, ye#22679, dataTime#22680, monname#22681, mon#22682]

(2) InMemoryRelation
Arguments: [F0000080#22678, ye#22679, dataTime#22680, monname#22681, mon#22682], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@1de3acb7,StorageLevel(disk, memory, deserialized, 1 replicas),*(2) SerializeFromObject [if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 0, F0000080), StringType), true, false) AS F0000080#22678, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 1, ye), StringType), true, false) AS ye#22679, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 2, dataTime), StringType), true, false) AS dataTime#22680, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 3, monname), StringType), true, false) AS monname#22681, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 4, mon), StringType), true, false) AS mon#22682]
+- *(2) MapElements smartbix.datamining.engine.execute.node.preprocess.ValueReplaceNode$2@4e4f6351, obj#22677: org.apache.spark.sql.Row
   +- *(2) DeserializeToObject createexternalrow(F0000080#22597.toString, ye#22598.toString, dataTime#22599.toString, monname#22648.toString, mon#22649.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true), StructField(monname,StringType,true), StructField(mon,StringType,true)), obj#22676: org.apache.spark.sql.Row
      +- Generate stack(12, dataTime_0, dataTime_0#22600, dataTime_1, dataTime_1#22601, dataTime_2, dataTime_2#22602, dataTime_3, dataTime_3#22603, dataTime_4, dataTime_4#22604, dataTime_5, dataTime_5#22605, dataTime_6, dataTime_6#22606, dataTime_7, dataTime_7#22607, dataTime_8, dataTime_8#22608, dataTime_9, dataTime_9#22609, dataTime_10, dataTime_10#22610, dataTime_11, dataTime_11#22611), [F0000080#22597, ye#22598, dataTime#22599], false, [monname#22648, mon#22649]
         +- *(1) SerializeFromObject [if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 0, F0000080), StringType), true, false) AS F0000080#22597, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 1, ye), StringType), true, false) AS ye#22598, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 2, dataTime), StringType), true, false) AS dataTime#22599, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 3, dataTime_0), StringType), true, false) AS dataTime_0#22600, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 4, dataTime_1), StringType), true, false) AS dataTime_1#22601, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 5, dataTime_2), StringType), true, false) AS dataTime_2#22602, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 6, dataTime_3), StringType), true, false) AS dataTime_3#22603, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 7, dataTime_4), StringType), true, false) AS dataTime_4#22604, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 8, dataTime_5), StringType), true, false) AS dataTime_5#22605, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 9, dataTime_6), StringType), true, false) AS dataTime_6#22606, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 10, dataTime_7), StringType), true, false) AS dataTime_7#22607, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 11, dataTime_8), StringType), true, false) AS dataTime_8#22608, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 12, dataTime_9), StringType), true, false) AS dataTime_9#22609, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 13, dataTime_10), StringType), true, false) AS dataTime_10#22610, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 14, dataTime_11), StringType), true, false) AS dataTime_11#22611]
            +- *(1) MapElements smartbix.datamining.engine.execute.node.preprocess.DivideNode$2@6a379505, obj#22596: org.apache.spark.sql.Row
               +- *(1) DeserializeToObject createexternalrow(F0000080#22477.toString, ye#22478.toString, dataTime#22479.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true)), obj#22595: org.apache.spark.sql.Row
                  +- *(1) Scan JDBCRelation(( SELECT 
	DISTINCT t1.F0000080,
	case when t4.ye<>''
	THEN t4.ye
	ELSE DATE_FORMAT(NOW(),'%Y') end  ye
	,
	'01-02-03-04-05-06-07-08-09-10-11-12' dataTime
	from (SELECT F0000080 from `立项审批` WHERE  `Status`='1' ) t1
	LEFT JOIN `井位信息` t2 on t2.ObjectId=t1.F0000080  and t2.`Status`='1'
	LEFT JOIN `井位运行情况表` t3 on t2.ObjectId=t3.F0000026 and t3.`Status`='1'
	LEFT JOIN(	
	SELECT DISTINCT F0000031,
	CASE  WHEN date_format(F0000030, '%d')>25  and date_format(F0000030, '%c')=12
		THEN date_format(F0000030, '%Y')+1
		ELSE date_format(F0000030, '%Y')
		END ye
	 FROM 	`日报填报` 
	 where Status='1' 
	 )t4 on t4.F0000031=t3.ObjectId 
 ) as T) [numPartitions=1] [F0000080#22477,ye#22478,dataTime#22479] PushedFilters: [], ReadSchema: struct<F0000080:string,ye:string,dataTime:string>
,None)

(3) Scan JDBCRelation(( SELECT 
	DISTINCT t1.F0000080,
	case when t4.ye<>''
	THEN t4.ye
	ELSE DATE_FORMAT(NOW(),'%Y') end  ye
	,
	'01-02-03-04-05-06-07-08-09-10-11-12' dataTime
	from (SELECT F0000080 from `立项审批` WHERE  `Status`='1' ) t1
	LEFT JOIN `井位信息` t2 on t2.ObjectId=t1.F0000080  and t2.`Status`='1'
	LEFT JOIN `井位运行情况表` t3 on t2.ObjectId=t3.F0000026 and t3.`Status`='1'
	LEFT JOIN(	
	SELECT DISTINCT F0000031,
	CASE  WHEN date_format(F0000030, '%d')>25  and date_format(F0000030, '%c')=12
		THEN date_format(F0000030, '%Y')+1
		ELSE date_format(F0000030, '%Y')
		END ye
	 FROM 	`日报填报` 
	 where Status='1' 
	 )t4 on t4.F0000031=t3.ObjectId 
 ) as T) [numPartitions=1]  [codegen id : 1]
Output [3]: [F0000080#22477, ye#22478, dataTime#22479]
ReadSchema: struct<F0000080:string,ye:string,dataTime:string>

(4) DeserializeToObject [codegen id : 1]
Input [3]: [F0000080#22477, ye#22478, dataTime#22479]
Arguments: createexternalrow(F0000080#22477.toString, ye#22478.toString, dataTime#22479.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true)), obj#22595: org.apache.spark.sql.Row

(5) MapElements [codegen id : 1]
Input [1]: [obj#22595]
Arguments: smartbix.datamining.engine.execute.node.preprocess.DivideNode$2@6a379505, obj#22596: org.apache.spark.sql.Row

(6) SerializeFromObject [codegen id : 1]
Input [1]: [obj#22596]
Arguments: [if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 0, F0000080), StringType), true, false) AS F0000080#22597, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 1, ye), StringType), true, false) AS ye#22598, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 2, dataTime), StringType), true, false) AS dataTime#22599, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 3, dataTime_0), StringType), true, false) AS dataTime_0#22600, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 4, dataTime_1), StringType), true, false) AS dataTime_1#22601, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 5, dataTime_2), StringType), true, false) AS dataTime_2#22602, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 6, dataTime_3), StringType), true, false) AS dataTime_3#22603, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 7, dataTime_4), StringType), true, false) AS dataTime_4#22604, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 8, dataTime_5), StringType), true, false) AS dataTime_5#22605, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 9, dataTime_6), StringType), true, false) AS dataTime_6#22606, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 10, dataTime_7), StringType), true, false) AS dataTime_7#22607, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 11, dataTime_8), StringType), true, false) AS dataTime_8#22608, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 12, dataTime_9), StringType), true, false) AS dataTime_9#22609, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 13, dataTime_10), StringType), true, false) AS dataTime_10#22610, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 14, dataTime_11), StringType), true, false) AS dataTime_11#22611]

(7) Generate
Input [15]: [F0000080#22597, ye#22598, dataTime#22599, dataTime_0#22600, dataTime_1#22601, dataTime_2#22602, dataTime_3#22603, dataTime_4#22604, dataTime_5#22605, dataTime_6#22606, dataTime_7#22607, dataTime_8#22608, dataTime_9#22609, dataTime_10#22610, dataTime_11#22611]
Arguments: stack(12, dataTime_0, dataTime_0#22600, dataTime_1, dataTime_1#22601, dataTime_2, dataTime_2#22602, dataTime_3, dataTime_3#22603, dataTime_4, dataTime_4#22604, dataTime_5, dataTime_5#22605, dataTime_6, dataTime_6#22606, dataTime_7, dataTime_7#22607, dataTime_8, dataTime_8#22608, dataTime_9, dataTime_9#22609, dataTime_10, dataTime_10#22610, dataTime_11, dataTime_11#22611), [F0000080#22597, ye#22598, dataTime#22599], false, [monname#22648, mon#22649]

(8) DeserializeToObject [codegen id : 2]
Input [5]: [F0000080#22597, ye#22598, dataTime#22599, monname#22648, mon#22649]
Arguments: createexternalrow(F0000080#22597.toString, ye#22598.toString, dataTime#22599.toString, monname#22648.toString, mon#22649.toString, StructField(F0000080,StringType,true), StructField(ye,StringType,true), StructField(dataTime,StringType,true), StructField(monname,StringType,true), StructField(mon,StringType,true)), obj#22676: org.apache.spark.sql.Row

(9) MapElements [codegen id : 2]
Input [1]: [obj#22676]
Arguments: smartbix.datamining.engine.execute.node.preprocess.ValueReplaceNode$2@4e4f6351, obj#22677: org.apache.spark.sql.Row

(10) SerializeFromObject [codegen id : 2]
Input [1]: [obj#22677]
Arguments: [if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 0, F0000080), StringType), true, false) AS F0000080#22678, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 1, ye), StringType), true, false) AS ye#22679, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 2, dataTime), StringType), true, false) AS dataTime#22680, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 3, monname), StringType), true, false) AS monname#22681, if (assertnotnull(input[0, org.apache.spark.sql.Row, true]).isNullAt) null else staticinvoke(class org.apache.spark.unsafe.types.UTF8String, StringType, fromString, validateexternaltype(getexternalrowfield(assertnotnull(input[0, org.apache.spark.sql.Row, true]), 4, mon), StringType), true, false) AS mon#22682]

(2) CollectLimit
Input [5]: [F0000080#22678, ye#22679, dataTime#22680, monname#22681, mon#22682]
Arguments: 100