{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"64fead9f7b7b18ade1bec545","instance_id":"f93436dd-afca-41e5-8d6b-2c325f533296","instance_version":4,"link_map":{"link118":{"dst_id":"2f40ca5b-7f8c-4555-b023-32c332f4dbc4","dst_view_id":"input102","src_id":"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9","src_view_id":"output101","isGoto":false},"link119":{"dst_id":"2f40ca5b-7f8c-4555-b023-32c332f4dbc4","dst_view_id":"input0","src_id":"d401aec4-7770-4113-89b4-c4a57d51be14","src_view_id":"output0","isGoto":false},"link121":{"dst_id":"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9","dst_view_id":"input102","src_id":"94142968-8fc8-4cd0-9ace-b2dfd9a81f6c","src_view_id":"output101","isGoto":false},"link122":{"dst_id":"1a5abf32-9ff2-44ab-b88a-1c767baba913","dst_view_id":"input0","src_id":"ccc91b47-3a61-4e08-bb4b-584778b4ee02","src_view_id":"output0","isGoto":false},"link123":{"dst_id":"ccc91b47-3a61-4e08-bb4b-584778b4ee02","dst_view_id":"input101","src_id":"2f40ca5b-7f8c-4555-b023-32c332f4dbc4","src_view_id":"output101","isGoto":false}},"link_serial":124,"property_map":{"info":{"notes":{"value":null},"author":{"value":"gbhagchandani@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Example_Parquet_Writer_With Second_Input_View"}},"error":{"error_behavior":{"value":"none"}},"settings":{"imports":{"value":[]},"suspendable":{"value":false},"error_param_table":{"value":[]},"param_table":{"value":[{"capture":{"value":false},"key":{"value":"dirpath"},"value":{"value":"abfs:///bigdataqa/"},"required":{"value":false},"data_type":{"value":"string"},"description":{"value":null}},{"capture":{"value":false},"key":{"value":"account"},"value":{"value":"ADLS_gen2_SSL"},"required":{"value":false},"data_type":{"value":"string"},"description":{"value":null}}]},"error_pipeline":{"expression":false,"value":null}},"input":{},"output":{"1a5abf32-9ff2-44ab-b88a-1c767baba913_output0":{"view_type":{"value":"document"},"label":{"value":"Mapper - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"62337f517354daa2a75aba0a","scale_ratio":1,"detail_map":{"d401aec4-7770-4113-89b4-c4a57d51be14":{"grid_x_int":3,"input":{},"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"output":{},"error":{}},"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"94142968-8fc8-4cd0-9ace-b2dfd9a81f6c":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"","grid_y_int":2,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"2f40ca5b-7f8c-4555-b023-32c332f4dbc4":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"input":{"input102":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"1a5abf32-9ff2-44ab-b88a-1c767baba913":{"grid_x_int":6,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":1,"rot_tail_int":0,"rot_int":0,"input":{},"output":{},"error":{}},"ccc91b47-3a61-4e08-bb4b-584778b4ee02":{"grid_x_int":5,"grid_y_int":1,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}}},"pan_y_num":0},"snap_map":{"d401aec4-7770-4113-89b4-c4a57d51be14":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-MULTIPLE5958","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"d401aec4-7770-4113-89b4-c4a57d51be14_1","instance_id":"d401aec4-7770-4113-89b4-c4a57d51be14","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator1"}},"view_serial":100,"settings":{"editable_content":{"value":"[\n {\n \"name\": \"Bob\",\n \"age\": 1,\n \"address\": \"Milpitas\"\n },\n {\n \"name\": \"Cathy\",\n \"age\": 2,\n \"address\": \"Milpitas\"\n },\n {\n \"name\": \"Tom\",\n \"age\": 3,\n \"address\": \"FosterCity\"\n }\n]"},"execution_mode":{"value":"Validate & Execute"},"arrayElementsAsDocuments":{"value":true},"passThroughProp":{"value":false},"supportTypeExts":{"value":false}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{}},"class_build_tag":"MULTIPLE5958"},"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9":{"class_fqid":"com-snaplogic-snaps-hive-execute_2-111506","class_id":"com-snaplogic-snaps-hive-execute","class_version":2,"instance_fqid":"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9_1","instance_id":"ac5ea204-5bea-4d66-93fb-1ccf7b4169e9","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Hive - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"HIVE_GenericJDBC_account_CDP","label":"HIVE_GenericJDBC_account_CDP","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-generichivedatabaseaccount"},"ref_id":{"value":"46b78e07-89ad-47f0-b2bc-8543fe198db0","expression":false}}}},"input":{"input102":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"sqlStatement":{"expression":false,"value":"Describe HiveStudent"},"queryType":{"value":"Auto","expression":false},"maxRetryProp":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"retryIntervalProp":{"expression":false,"value":1},"passThrough":{"value":true},"confProperties":{"value":[]},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"111506"},"94142968-8fc8-4cd0-9ace-b2dfd9a81f6c":{"class_fqid":"com-snaplogic-snaps-hive-execute_2-111506","class_id":"com-snaplogic-snaps-hive-execute","class_version":2,"instance_fqid":"94142968-8fc8-4cd0-9ace-b2dfd9a81f6c_1","instance_id":"94142968-8fc8-4cd0-9ace-b2dfd9a81f6c","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Hive - Execute"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"HIVE_GenericJDBC_account_CDP","label":"HIVE_GenericJDBC_account_CDP","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-generichivedatabaseaccount"},"ref_id":{"value":"46b78e07-89ad-47f0-b2bc-8543fe198db0","expression":false}}}},"settings":{"sqlStatement":{"expression":false,"value":"create table if not exists HiveStudent(name String, age int, address String)\nrow format delimited fields terminated by ',' "},"queryType":{"value":"Auto","expression":false},"maxRetryProp":{"expression":false,"value":0},"execution_mode":{"value":"Validate & Execute"},"retryIntervalProp":{"expression":false,"value":1},"passThrough":{"value":true},"confProperties":{"value":[]},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":true}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"input":{}},"class_build_tag":"111506"},"2f40ca5b-7f8c-4555-b023-32c332f4dbc4":{"class_fqid":"com-snaplogic-snaps-hadoop-parquetwritingformatter_1-MULTIPLE5964","class_id":"com-snaplogic-snaps-hadoop-parquetwritingformatter","class_version":1,"instance_fqid":"2f40ca5b-7f8c-4555-b023-32c332f4dbc4_2","instance_id":"2f40ca5b-7f8c-4555-b023-32c332f4dbc4","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Parquet Writer"}},"view_serial":102,"account":{"account_ref":{"value":{"label":{"value":"ADLS_gen2_SSL","label":"ADLS_gen2_SSL","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-binary-abfsaccount"},"ref_id":{"value":"ab18a0bf-ceae-4e77-a310-dfe9bd7bdd35","expression":false}}}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"data"}},"input102":{"view_type":{"value":"document"},"label":{"value":"input1"}}},"settings":{"partitionBy":{"value":[]},"sasUriPropertiesKey":{"value":{"sasUriKey":{"value":null,"expression":false}}},"Compression":{"value":"NONE"},"execution_mode":{"value":"Validate & Execute"},"hiveMetastore":{"expression":false,"value":null},"directory":{"expression":true,"value":"_dirpath"},"table":{"expression":false,"value":null},"UserImpersonation":{"value":false},"useMetastore":{"value":false},"filter":{"expression":false,"value":"*"},"executable_during_suggest":{"value":true},"database":{"expression":false,"value":null},"file":{"expression":false,"value":"TestFile2nd.parquet"},"editable_content":{"value":null}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"MULTIPLE5964"},"1a5abf32-9ff2-44ab-b88a-1c767baba913":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-MULTIPLE6930","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"1a5abf32-9ff2-44ab-b88a-1c767baba913_1","instance_id":"1a5abf32-9ff2-44ab-b88a-1c767baba913","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$age"},"targetPath":{"value":"age"}},{"expression":{"value":"$address","expression":true},"targetPath":{"value":"address"}},{"expression":{"value":"$name","expression":true},"targetPath":{"value":"name"}}]},"mappingRoot":{"value":"$"}}},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"MULTIPLE6930"},"ccc91b47-3a61-4e08-bb4b-584778b4ee02":{"class_fqid":"com-snaplogic-snaps-hadoop-parquetreadingparser_1-433patches22297","class_id":"com-snaplogic-snaps-hadoop-parquetreadingparser","class_version":1,"instance_fqid":"ccc91b47-3a61-4e08-bb4b-584778b4ee02_1","instance_id":"ccc91b47-3a61-4e08-bb4b-584778b4ee02","instance_version":1,"property_map":{"info":{"label":{"value":"Parquet Reader"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"useOldDataFormat":{"value":true},"sasUriPropertiesKey":{"value":{"sasUriKey":{"value":null,"expression":false}}},"execution_mode":{"value":"Validate & Execute"},"directory":{"value":null,"expression":false},"dateTimeFormat":{"value":"yyyy-MM-dd'T'HH:mm:ss.SSSX","expression":false},"ignoreEmptyFile":{"value":true},"useDateTimeTypes":{"value":false},"int96AsTimestamp":{"value":false},"filter":{"value":"*","expression":false},"file":{"value":"$filename","expression":true}},"account":{"account_ref":{"value":{"label":{"value":"ADLS_gen2_SSL","label":"ADLS_gen2_SSL","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-binary-abfsaccount"},"ref_id":{"value":"ab18a0bf-ceae-4e77-a310-dfe9bd7bdd35","expression":false}}}},"view_serial":101,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"433patches22297"}},"path_id":"/QA/qa_diagnostic_space/Bigdata_diagnostic","path_snode":"5daa0cfc48bd893bfeeb1660","target_runtime":"standard"}