Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

unique constraint violated - in index primary of type primary over '_key'; conflicting key #925

Closed
rsaw4 opened this issue Jul 2, 2021 · 15 comments
Closed

unique constraint violated - in index primary of type primary over '_key'; conflicting key #925

rsaw4 opened this issue Jul 2, 2021 · 15 comments
Assignees
@wajda
Labels
bug component: Producer
Milestone
0.6.1

Comments

@rsaw4
Copy link

rsaw4 commented Jul 2, 2021 •
edited
Loading

using docker quickstart with latest spline versions, spark 2.4, rest server logs have:

00:44:10.770 [http-nio-8080-exec-1] ERROR za.co.absa.commons.error.ErrorRef - ERROR_ID [10dff2fa-4261-42f0-aa42-bbf394b6b3b4]
java.util.concurrent.CompletionException: com.arangodb.ArangoDBException: Response: 409, Error: 1210 - unique constraint violated - in index primary of type primary over '_key'; conflicting key: 2cf4dcdb-1c9d-4a26-9f4e-47236db5393f:565
        at java.base/java.util.concurrent.CompletableFuture.encodeRelay(CompletableFuture.java:367)
        at java.base/java.util.concurrent.CompletableFuture.completeRelay(CompletableFuture.java:376)
        at java.base/java.util.concurrent.CompletableFuture$UniRelay.tryFire(CompletableFuture.java:1019)
        at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
        at java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088)
        at com.arangodb.async.internal.velocystream.VstCommunicationAsync.lambda$execute$1(VstCommunicationAsync.java:92)
        at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
        at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
        at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
        at java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
        at com.arangodb.async.internal.velocystream.VstConnectionAsync.lambda$write$0(VstConnectionAsync.java:51)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at com.arangodb.internal.velocystream.internal.MessageStore.consume(MessageStore.java:62)
        at com.arangodb.internal.velocystream.internal.ChunkStore.checkCompleteness(ChunkStore.java:65)
        at com.arangodb.internal.velocystream.internal.ChunkStore.checkCompleteness(ChunkStore.java:59)
        at com.arangodb.internal.velocystream.internal.VstConnection.lambda$open$0(VstConnection.java:218)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.arangodb.ArangoDBException: Response: 409, Error: 1210 - unique constraint violated - in index primary of type primary over '_key'; conflicting key: 2cf4dcdb-1c9d-4a26-9f4e-47236db5393f:565
        at com.arangodb.internal.util.ResponseUtils.checkError(ResponseUtils.java:52)
        at com.arangodb.internal.velocystream.VstCommunication.checkError(VstCommunication.java:147)
        at com.arangodb.async.internal.velocystream.VstCommunicationAsync.lambda$execute$1(VstCommunicationAsync.java:74)
        ... 14 common frames omitted
@rsaw4 rsaw4 added the bug label Jul 2, 2021
@rsaw4
Copy link
Author

rsaw4 commented Jul 2, 2021

related to AbsaOSS/spline-spark-agent#265, error comes at same time

@rsaw4 rsaw4 mentioned this issue Jul 2, 2021
Closed
@cerveada
Copy link
Contributor

cerveada commented Jul 2, 2021

Thanks for reporting the issue.

Could you try to look into arangodb and find out what object has the key 2cf4dcdb-1c9d-4a26-9f4e-47236db5393f:565 ?
From it you may be able to find out which Spark operation is causing the duplication.

From the log I can see some duplication is happening, but without being able to replicate that It might not be possible to find and fix the cause.

@kuhnen
Copy link

kuhnen commented Jul 5, 2021 •
edited
Loading

Hello, I got exactly the same error: java.lang.RuntimeException: Cannot send lineage data to http://0.0.0.0:8080/producer/execution-plans. HTTP Response: 500 {"errorId":"d9b4598c-32cd-426c-b619-5d91d127d3ee","timestamp":1625504823983,"message":null}. Looking at the collection executionPLan, I can see that it is empty. Any ideas? Could it be the case, the complexity of the job?

@kuhnen
Copy link

kuhnen commented Jul 5, 2021 •
edited by wajda
Loading

I believe the problem is the size of the lienage, I used console and it worked fine.

["plan",{"id":"a3872ecd-d49e-4ea9-926e-6f796a08e26b","name":"CustomerTransactionAdcellCn","operations":{"write":{"outputSource":"s3a://gsg-bi-staging-data-lake-dev/datamarts/bi/customer_transactions/complete/2021-07-05T00-00-00","append":false,"id":"0","name":"InsertIntoHadoopFsRelationCommand","childIds":["1"],"params":{"compression":"snappy","encoding":"UTF-8","__partition_columns":"[\"affiliate_network\"]","path":"s3a://gsg-bi-staging-data-lake-dev/datamarts/bi/customer_transactions/complete/2021-07-05T00-00-00"},"extra":{"destinationType":"parquet"}},"reads":[{"inputSources":["s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"],"id":"123","name":"LogicalRelation","output":["678","679","680","681","682","683","684","685","686","687","688","689","690","691","692","693","694","695","696","697","698","699","700","701","702","703","704","705","706"],"params":{"mergeschema":"true","path":"s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"},"extra":{"sourceType":"parquet"}},{"inputSources":["s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"],"id":"61","name":"LogicalRelation","output":["60","61","62","63","64","65","66","67","68","69","70","71","72","73","74","75","76","77","78","79","80","81","82","83","84","85","86","87","88"],"params":{"mergeschema":"true","path":"s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"},"extra":{"sourceType":"parquet"}},{"inputSources":["s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"],"id":"91","name":"LogicalRelation","output":["199","200","201","202","203","204","205","206","207","208","209","210","211","212","213","214","215","216","217","218","219","220","221","222","223","224","225","226","227"],"params":{"mergeschema":"true","path":"s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions_history/complete/2021-07-05T00-00-00"},"extra":{"sourceType":"parquet"}},{"inputSources":["s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions/complete/2021-07-05T00-00-00"],"id":"44","name":"LogicalRelation","output":["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"],"params":{"mergeschema":"true","path":"s3a://gsg-bi-staging-data-lake/dumps/affiliate_networks/adcell_transactions/complete/2021-07-05T00-00-00"},"extra":{"sourceType":"parquet"}}],"other":[{"id":"122","name":"Project","childIds":["123"],"output":["705","693","694","700","691"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"}]}},{"id":"60","name":"Project","childIds":["61"],"output":["87","75","76","82","73"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"}]}},{"id":"90","name":"Project","childIds":["91"],"output":["226","214","215","221","212"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"214"},{"__attrId":"215"},{"__attrId":"221"},{"__attrId":"212"}]}},{"id":"43","name":"Project","childIds":["44"],"output":["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"3"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"9"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__exprId":"74f65fbf-b8bf-447d-af56-fe911f500776"}]}},{"id":"121","name":"Project","childIds":["122"],"output":["705","693","694","700","691","123"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"},{"__exprId":"55df7ee0-b739-4034-a68d-2a7188fd8aa5"}]}},{"id":"59","name":"Project","childIds":["60"],"output":["87","75","76","82","73","123"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__exprId":"addc1cfe-97ce-41a0-96fd-86c5c800a4b1"}]}},{"id":"89","name":"Project","childIds":["90"],"output":["226","214","215","221","212","123"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"214"},{"__attrId":"215"},{"__attrId":"221"},{"__attrId":"212"},{"__exprId":"d7920062-6d8d-410d-9287-fbd949ca44f5"}]}},{"id":"42","name":"Project","childIds":["43"],"output":["0","1","2","296","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__exprId":"cedeb398-25b2-40ae-95d7-a1e55af0e744"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"9"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"}]}},{"id":"120","name":"Project","childIds":["121"],"output":["705","693","694","700","691","123","591"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"},{"__attrId":"123"},{"__exprId":"ebbd77d9-232d-4bad-987e-ef0757ddff56"}]}},{"id":"107","name":"Project","childIds":["59"],"output":["87","75","76","82","73","123","591"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"123"},{"__exprId":"779cc179-2ed8-41c5-8f53-a533b7f8ec1a"}]}},{"id":"77","name":"Project","childIds":["59"],"output":["87","82","73"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"}]}},{"id":"58","name":"Project","childIds":["59"],"output":["87","75","76","82","123"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"123"}]}},{"id":"88","name":"Project","childIds":["89"],"output":["226","221","212"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"221"},{"__attrId":"212"}]}},{"id":"41","name":"Project","childIds":["42"],"output":["0","1","2","296","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"9"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__exprId":"9de8a48a-e604-4eea-88f3-c43af1ca758d"}]}},{"id":"119","name":"Project","childIds":["120"],"output":["705","693","694","700","691","599","591"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"},{"__exprId":"7fbee5ea-8ef2-4e75-bf51-71d95e5258a2"},{"__attrId":"591"}]}},{"id":"106","name":"Project","childIds":["107"],"output":["87","75","76","82","73","599","591"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__exprId":"7de2e81a-7fba-4807-9487-0a77b28db75d"},{"__attrId":"591"}]}},{"id":"76","name":"Project","childIds":["77"],"output":["87","82","73","178"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__exprId":"0a1786d4-1c67-4bfd-ae4a-4c048685f6b8"}]}},{"id":"57","name":"Project","childIds":["58"],"output":["87","75","135","82","123"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__exprId":"00a0c5c8-5d29-4d74-8df7-824877a032e4"},{"__attrId":"82"},{"__attrId":"123"}]}},{"id":"87","name":"Project","childIds":["88"],"output":["226","221","212","178"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"221"},{"__attrId":"212"},{"__exprId":"21e5024e-7a1c-463e-90c4-88788d079d22"}]}},{"id":"40","name":"Project","childIds":["41"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__exprId":"691b6596-7258-4369-87a3-1a9fce3ec811"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"}]}},{"id":"118","name":"Project","childIds":["119"],"output":["705","693","694","700","691","599","591","607"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"},{"__attrId":"599"},{"__attrId":"591"},{"__exprId":"bd5c72a8-d98d-4e0e-b64f-47afff22c934"}]}},{"id":"105","name":"Project","childIds":["106"],"output":["87","75","76","82","73","599","591","607"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__exprId":"04fe3e57-b838-48b6-8423-8c835fad6475"}]}},{"id":"56","name":"Project","childIds":["57"],"output":["87","141","135","82","123"],"params":{"projectList":[{"__attrId":"87"},{"__exprId":"52bf10da-ffd1-4115-b9b5-406ba9530114"},{"__attrId":"135"},{"__attrId":"82"},{"__attrId":"123"}]}},{"id":"86","name":"Project","childIds":["87"],"output":["226","178","221"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"178"},{"__attrId":"221"}]}},{"id":"39","name":"Project","childIds":["40"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328","394"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"361"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"},{"__exprId":"e8420c2b-d62b-4e60-abe5-ab05cd91fe13"}]}},{"id":"117","name":"Project","childIds":["118"],"output":["705","693","694","700","691","599","591","607"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"693"},{"__attrId":"694"},{"__attrId":"700"},{"__attrId":"691"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"607"}]}},{"id":"104","name":"Project","childIds":["105"],"output":["87","75","76","82","73","599","591","607"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"607"}]}},{"id":"55","name":"Filter","childIds":["56"],"output":["87","141","135","82","123"],"params":{"condition":{"__exprId":"9117093a-a031-40e5-924c-3b1ab7bc01d5"}}},{"id":"85","name":"Filter","childIds":["86"],"output":["226","178","221"],"params":{"condition":{"__exprId":"97f29f92-18e2-4d51-b98f-2b9cd8301900"}}},{"id":"38","name":"Project","childIds":["39"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328","394","428"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"361"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"},{"__attrId":"394"},{"__exprId":"570640a6-db95-4f35-86ce-21703b99258c"}]}},{"id":"116","name":"Project","childIds":["117"],"output":["705","662","663","700","607"],"params":{"projectList":[{"__attrId":"705"},{"__exprId":"a609e273-9eb4-4aa7-91c9-b297239cf475"},{"__exprId":"7f567f50-02f9-4603-bba8-ae0e07af34b1"},{"__attrId":"700"},{"__attrId":"607"}]}},{"id":"103","name":"Filter","childIds":["104"],"output":["87","75","76","82","73","599","591","607"],"params":{"condition":{"__exprId":"39b211e6-b9b2-4647-aa76-acfb88b711cc"}}},{"id":"54","name":"Project","childIds":["55"],"output":["87","135","141","82"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"135"},{"__attrId":"141"},{"__attrId":"82"}]}},{"id":"84","name":"Project","childIds":["85"],"output":["226","178","221"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"178"},{"__attrId":"221"}]}},{"id":"37","name":"Project","childIds":["38"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328","394","428","463"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"361"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"},{"__attrId":"394"},{"__attrId":"428"},{"__exprId":"72519f95-643e-49e6-ad5e-1dfeecbd6564"}]}},{"id":"115","name":"Filter","childIds":["116"],"output":["705","662","663","700","607"],"params":{"condition":{"__exprId":"98cb1724-e454-4bfe-a8ee-3c585aa0fac2"}}},{"id":"102","name":"Project","childIds":["103"],"output":["87","75","76","82","73","599","591"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"}]}},{"id":"53","name":"Project","childIds":["54"],"output":["87","151","141","82"],"params":{"projectList":[{"__attrId":"87"},{"__exprId":"04b783ae-e54f-4cd6-aed5-619afb5fb49e"},{"__attrId":"141"},{"__attrId":"82"}]}},{"id":"83","name":"Window","childIds":["84"],"output":["226","178","221","187"],"params":{"windowExpressions":[{"__exprId":"386e2f3f-1226-4225-b376-01734c939278"}],"partitionSpec":[{"__attrId":"226"}],"orderSpec":[{"expression":{"__attrId":"221"},"direction":"ASC","nullOrdering":"NULLS FIRST"}]}},{"id":"36","name":"Project","childIds":["37"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328","394","428","463","499"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"361"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"},{"__attrId":"394"},{"__attrId":"428"},{"__attrId":"463"},{"__exprId":"bc2f0b75-85ee-4e37-91eb-ce6b6deef4e0"}]}},{"id":"114","name":"Project","childIds":["115"],"output":["705","662","663","700"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"662"},{"__attrId":"663"},{"__attrId":"700"}]}},{"id":"52","name":"Project","childIds":["53"],"output":["87","151","156","82"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__exprId":"b19c6512-dcc5-45c2-b4d2-78c3e5047a5e"},{"__attrId":"82"}]}},{"id":"82","name":"Project","childIds":["83"],"output":["226","178","221","187","187"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"178"},{"__attrId":"221"},{"__attrId":"187"},{"__attrId":"187"}]}},{"id":"35","name":"Project","childIds":["36"],"output":["0","1","2","296","4","5","6","7","8","361","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","264","328","394","428","463","499","536"],"params":{"projectList":[{"__attrId":"0"},{"__attrId":"1"},{"__attrId":"2"},{"__attrId":"296"},{"__attrId":"4"},{"__attrId":"5"},{"__attrId":"6"},{"__attrId":"7"},{"__attrId":"8"},{"__attrId":"361"},{"__attrId":"10"},{"__attrId":"11"},{"__attrId":"12"},{"__attrId":"13"},{"__attrId":"14"},{"__attrId":"15"},{"__attrId":"16"},{"__attrId":"17"},{"__attrId":"18"},{"__attrId":"19"},{"__attrId":"20"},{"__attrId":"21"},{"__attrId":"22"},{"__attrId":"23"},{"__attrId":"24"},{"__attrId":"25"},{"__attrId":"26"},{"__attrId":"27"},{"__attrId":"28"},{"__attrId":"29"},{"__attrId":"264"},{"__attrId":"328"},{"__attrId":"394"},{"__attrId":"428"},{"__attrId":"463"},{"__attrId":"499"},{"__exprId":"84625252-c9d5-433e-bfae-34f93d6a09d5"}]}},{"id":"113","name":"Project","childIds":["114"],"output":["705","662","663","700"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"662"},{"__attrId":"663"},{"__attrId":"700"}]}},{"id":"51","name":"Project","childIds":["52"],"output":["87","151","156","82"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"82"}]}},{"id":"81","name":"Project","childIds":["82"],"output":["226","178","221","187"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"178"},{"__attrId":"221"},{"__attrId":"187"}]}},{"id":"34","name":"Project","childIds":["35"],"output":["21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","27","536"],"params":{"projectList":[{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"463"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"394"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"27"},{"__attrId":"536"}]}},{"id":"112","name":"Window","childIds":["113"],"output":["705","662","663","700","669"],"params":{"windowExpressions":[{"__exprId":"5ad81d12-2183-4c96-b2d1-41ac17f7f3ec"}],"partitionSpec":[{"__attrId":"705"}],"orderSpec":[{"expression":{"__attrId":"700"},"direction":"DESC","nullOrdering":"NULLS LAST"}]}},{"id":"50","name":"Window","childIds":["51"],"output":["87","151","156","82","162"],"params":{"windowExpressions":[{"__exprId":"df78bf2c-5bf2-4fd2-a33d-0ceca2556f8e"}],"partitionSpec":[{"__attrId":"87"}],"orderSpec":[{"expression":{"__attrId":"82"},"direction":"ASC","nullOrdering":"NULLS FIRST"}]}},{"id":"80","name":"Filter","childIds":["81"],"output":["226","178","221","187"],"params":{"condition":{"__exprId":"9fddbf16-d667-444d-bad6-a554b463cbbb"}}},{"id":"111","name":"Project","childIds":["112"],"output":["705","662","663","700","669","669"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"662"},{"__attrId":"663"},{"__attrId":"700"},{"__attrId":"669"},{"__attrId":"669"}]}},{"id":"49","name":"Project","childIds":["50"],"output":["87","151","156","82","162","162"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"82"},{"__attrId":"162"},{"__attrId":"162"}]}},{"id":"79","name":"Project","childIds":["80"],"output":["226","178","192","187"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"178"},{"__exprId":"8a290b0a-6ffa-4367-878c-e5bc2c77d1d3"},{"__attrId":"187"}]}},{"id":"110","name":"Project","childIds":["111"],"output":["705","662","663","700","669"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"662"},{"__attrId":"663"},{"__attrId":"700"},{"__attrId":"669"}]}},{"id":"48","name":"Project","childIds":["49"],"output":["87","151","156","82","162"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"82"},{"__attrId":"162"}]}},{"id":"78","name":"Project","childIds":["79"],"output":["226","192"],"params":{"projectList":[{"__attrId":"226"},{"__attrId":"192"}]}},{"id":"109","name":"Filter","childIds":["110"],"output":["705","662","663","700","669"],"params":{"condition":{"__exprId":"718469ab-993e-4bf9-aa88-65298a7adbd3"}}},{"id":"47","name":"Filter","childIds":["48"],"output":["87","151","156","82","162"],"params":{"condition":{"__exprId":"fd7a011d-f287-4bf6-9566-a009f549d213"}}},{"id":"75","name":"Join","childIds":["76","78"],"output":["87","82","73","178","226","192"],"params":{"condition":{"__exprId":"fbcc6b8a-561c-44fb-9e0c-80490a8a2fd9"},"hint":"","joinType":"LEFT OUTER"}},{"id":"108","name":"Project","childIds":["109"],"output":["705","662","663"],"params":{"projectList":[{"__attrId":"705"},{"__attrId":"662"},{"__attrId":"663"}]}},{"id":"46","name":"Project","childIds":["47"],"output":["87","151","156","82"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"82"}]}},{"id":"74","name":"Project","childIds":["75"],"output":["87","82","73","178","192"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"}]}},{"id":"101","name":"Join","childIds":["102","108"],"output":["87","75","76","82","73","599","591","705","662","663"],"params":{"condition":{"__exprId":"7b317665-569f-4be8-bfd3-13c04d980c77"},"hint":"","joinType":"INNER"}},{"id":"45","name":"Project","childIds":["46"],"output":["87","151","156"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"151"},{"__attrId":"156"}]}},{"id":"73","name":"Project","childIds":["74"],"output":["87","82","73","178","192"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"}]}},{"id":"100","name":"Project","childIds":["101"],"output":["87","75","76","82","73","599","591","662","663"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"662"},{"__attrId":"663"}]}},{"id":"33","name":"Join","childIds":["34","45"],"output":["21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","27","536","87","151","156"],"params":{"condition":{"__exprId":"bf11ca22-bc33-40db-aafb-6fa0a58f408d"},"hint":"","joinType":"INNER"}},{"id":"72","name":"Window","childIds":["73"],"output":["87","82","73","178","192","233"],"params":{"windowExpressions":[{"__exprId":"4f00c4da-01a1-4a64-a66a-e42fbdab1e2f"}],"partitionSpec":[{"__attrId":"87"}],"orderSpec":[{"expression":{"__attrId":"82"},"direction":"ASC","nullOrdering":"NULLS FIRST"}]}},{"id":"99","name":"Project","childIds":["100"],"output":["87","75","76","82","73","599","591","716","663"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__exprId":"5dc1e339-64c1-42db-bc93-df72462e18c3"},{"__attrId":"663"}]}},{"id":"32","name":"Project","childIds":["33"],"output":["27","21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","536","151","156"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"463"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"394"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"}]}},{"id":"71","name":"Project","childIds":["72"],"output":["87","82","73","178","192","233","233"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"},{"__attrId":"233"}]}},{"id":"98","name":"Project","childIds":["99"],"output":["87","75","76","82","73","599","591","716","726"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"716"},{"__exprId":"1261bd7a-e79e-49c8-82b8-1bca098a5d40"}]}},{"id":"70","name":"Project","childIds":["71"],"output":["87","82","73","178","192","233"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"}]}},{"id":"97","name":"Project","childIds":["98"],"output":["87","75","76","82","73","599","591","716","726"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"716"},{"__attrId":"726"}]}},{"id":"69","name":"Project","childIds":["70"],"output":["87","82","73","178","192","233","240"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"},{"__exprId":"b817a1b9-3376-4f2c-a81b-16c86913ee66"}]}},{"id":"96","name":"Window","childIds":["97"],"output":["87","75","76","82","73","599","591","716","726","737"],"params":{"windowExpressions":[{"__exprId":"2aad6e3a-c25b-4fb4-b323-f766428a32a4"}],"partitionSpec":[{"__attrId":"87"}],"orderSpec":[{"expression":{"__attrId":"82"},"direction":"DESC","nullOrdering":"NULLS LAST"}]}},{"id":"68","name":"Project","childIds":["69"],"output":["87","82","73","178","192","233","240"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"},{"__attrId":"240"}]}},{"id":"95","name":"Project","childIds":["96"],"output":["87","75","76","82","73","599","591","716","726","737","737"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"716"},{"__attrId":"726"},{"__attrId":"737"},{"__attrId":"737"}]}},{"id":"67","name":"Window","childIds":["68"],"output":["87","82","73","178","192","233","240","249"],"params":{"windowExpressions":[{"__exprId":"f7bdfab8-3323-409a-9bf7-33c9e7e4eae1"}],"partitionSpec":[{"__attrId":"87"}],"orderSpec":[{"expression":{"__attrId":"82"},"direction":"DESC","nullOrdering":"NULLS LAST"}]}},{"id":"94","name":"Project","childIds":["95"],"output":["87","75","76","82","73","599","591","716","726","737"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"75"},{"__attrId":"76"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"599"},{"__attrId":"591"},{"__attrId":"716"},{"__attrId":"726"},{"__attrId":"737"}]}},{"id":"66","name":"Project","childIds":["67"],"output":["87","82","73","178","192","233","240","249","249"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"},{"__attrId":"240"},{"__attrId":"249"},{"__attrId":"249"}]}},{"id":"93","name":"Filter","childIds":["94"],"output":["87","75","76","82","73","599","591","716","726","737"],"params":{"condition":{"__exprId":"a6125d71-c195-421a-827d-066021062409"}}},{"id":"65","name":"Project","childIds":["66"],"output":["87","82","73","178","192","233","240","249"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"82"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"192"},{"__attrId":"233"},{"__attrId":"240"},{"__attrId":"249"}]}},{"id":"92","name":"Project","childIds":["93"],"output":["87","716","726"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"716"},{"__attrId":"726"}]}},{"id":"64","name":"Filter","childIds":["65"],"output":["87","82","73","178","192","233","240","249"],"params":{"condition":{"__exprId":"367544a9-f532-4c72-a172-dd79f8d56491"}}},{"id":"63","name":"Project","childIds":["64"],"output":["87","73","178","240"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"73"},{"__attrId":"178"},{"__attrId":"240"}]}},{"id":"62","name":"Project","childIds":["63"],"output":["87","240"],"params":{"projectList":[{"__attrId":"87"},{"__attrId":"240"}]}},{"id":"31","name":"Join","childIds":["32","62"],"output":["27","21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","536","151","156","87","240"],"params":{"condition":{"__exprId":"44536478-ffc3-4da5-84f4-97cc706daa79"},"hint":"","joinType":"INNER"}},{"id":"30","name":"Project","childIds":["31"],"output":["27","21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"463"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"394"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"29","name":"Join","childIds":["30","92"],"output":["27","21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","536","151","156","240","87","716","726"],"params":{"condition":{"__exprId":"1b358996-265a-4375-af2f-43ccdcff40e0"},"hint":"","joinType":"LEFT OUTER"}},{"id":"28","name":"Project","childIds":["29"],"output":["27","21","328","264","463","361","23","394","296","499","428","26","25","18","22","28","536","151","156","240","716","726"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"463"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"394"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"},{"__attrId":"716"},{"__attrId":"726"}]}},{"id":"27","name":"Project","childIds":["28"],"output":["27","21","328","264","463","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240","716","726"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"463"},{"__attrId":"361"},{"__attrId":"23"},{"__exprId":"71256fc7-359c-4429-af54-896465c630cb"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"},{"__attrId":"716"},{"__attrId":"726"}]}},{"id":"26","name":"Project","childIds":["27"],"output":["27","21","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240","716","726"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__exprId":"c649fcc4-565b-45d3-abd0-0d955f9552bc"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"},{"__attrId":"716"},{"__attrId":"726"}]}},{"id":"25","name":"Project","childIds":["26"],"output":["27","21","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240","726"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"},{"__attrId":"726"}]}},{"id":"24","name":"Project","childIds":["25"],"output":["27","21","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"27"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"23","name":"RepartitionByExpression","childIds":["24"],"output":["27","21","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"partitionExpressions":[{"expression":{"__attrId":"28"},"direction":"ASC","nullOrdering":"NULLS FIRST"}],"optNumPartitions":4}},{"id":"22","name":"Project","childIds":["23"],"output":["863","21","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__exprId":"1e67f76c-df9a-4b22-a6d0-a07913e2d961"},{"__attrId":"21"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"21","name":"Project","childIds":["22"],"output":["863","884","328","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__exprId":"5d5077f4-a04f-4b3f-866d-3c2c984f8d9d"},{"__attrId":"328"},{"__attrId":"264"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"20","name":"Project","childIds":["21"],"output":["863","884","905","264","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__exprId":"724cfbe5-e797-409e-9858-4b716b274e80"},{"__attrId":"264"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"19","name":"Project","childIds":["20"],"output":["863","884","905","926","799","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__exprId":"ab789527-973c-43fa-bcb8-308bb3d441d2"},{"__attrId":"799"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"18","name":"Project","childIds":["19"],"output":["863","884","905","926","947","361","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__exprId":"2264a5ea-bf12-4c9f-99db-1584968c29af"},{"__attrId":"361"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"17","name":"Project","childIds":["18"],"output":["863","884","905","926","947","968","23","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__exprId":"073852da-b3d7-447c-924a-5aad2a5e18b7"},{"__attrId":"23"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"16","name":"Project","childIds":["17"],"output":["863","884","905","926","947","968","989","776","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__exprId":"b955d63c-2bb5-4336-86ac-2beac87316f8"},{"__attrId":"776"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"15","name":"Project","childIds":["16"],"output":["863","884","905","926","947","968","989","1010","296","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__exprId":"4b911110-309f-4394-b044-40e47cbd1cd2"},{"__attrId":"296"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"14","name":"Project","childIds":["15"],"output":["863","884","905","926","947","968","989","1010","1031","499","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__exprId":"5194b68b-7a0b-42a3-84a4-45d42fa1433e"},{"__attrId":"499"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"13","name":"Project","childIds":["14"],"output":["863","884","905","926","947","968","989","1010","1031","1052","428","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__exprId":"59de4722-7560-4148-bc5d-f399f0a2aa56"},{"__attrId":"428"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"12","name":"Project","childIds":["13"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","26","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__exprId":"15c4623b-43a0-4582-9a4f-e042d8c0c132"},{"__attrId":"26"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"11","name":"Project","childIds":["12"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","25","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__exprId":"e1a3b3cd-eca6-44dc-b0f0-5e0479e0e23d"},{"__attrId":"25"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"10","name":"Project","childIds":["11"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","18","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__exprId":"9c386400-1883-47cb-b742-5f2ce22dfe6f"},{"__attrId":"18"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"9","name":"Project","childIds":["10"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","22","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__exprId":"4616a7c3-a90e-493e-8d63-2924821b0f22"},{"__attrId":"22"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"8","name":"Project","childIds":["9"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","28","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__exprId":"a7e75a99-cc7a-4ae2-9fac-919c7b52582a"},{"__attrId":"28"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"7","name":"Project","childIds":["8"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","536","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__exprId":"7f4e059b-b887-4518-a94a-9347d5f7d4f6"},{"__attrId":"536"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"6","name":"Project","childIds":["7"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","151","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__exprId":"35813355-3089-4674-9d6c-a1598f2e6939"},{"__attrId":"151"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"5","name":"Project","childIds":["6"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","1220","156","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__attrId":"1199"},{"__exprId":"fd92a1fd-de36-42de-90ff-9172ac392fd5"},{"__attrId":"156"},{"__attrId":"240"}]}},{"id":"4","name":"Project","childIds":["5"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","1220","1241","240"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__attrId":"1199"},{"__attrId":"1220"},{"__exprId":"e20f05cf-52a9-4927-a006-c8bedad935f4"},{"__attrId":"240"}]}},{"id":"3","name":"Project","childIds":["4"],"output":["863","884","905","926","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","1220","1241","1262"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"926"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__attrId":"1199"},{"__attrId":"1220"},{"__attrId":"1241"},{"__exprId":"9be27bc3-4754-4cbb-89e8-e8b0d4618844"}]}},{"id":"2","name":"Project","childIds":["3"],"output":["863","884","905","1283","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","1220","1241","1262"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__exprId":"cb523fd2-c05c-4c8d-94fb-b9f50a166a15"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__attrId":"1199"},{"__attrId":"1220"},{"__attrId":"1241"},{"__attrId":"1262"}]}},{"id":"1","name":"Project","childIds":["2"],"output":["863","884","905","1283","947","968","989","1010","1031","1052","1073","1094","1115","1136","1157","1178","1199","1220","1241","1304"],"params":{"projectList":[{"__attrId":"863"},{"__attrId":"884"},{"__attrId":"905"},{"__attrId":"1283"},{"__attrId":"947"},{"__attrId":"968"},{"__attrId":"989"},{"__attrId":"1010"},{"__attrId":"1031"},{"__attrId":"1052"},{"__attrId":"1073"},{"__attrId":"1094"},{"__attrId":"1115"},{"__attrId":"1136"},{"__attrId":"1157"},{"__attrId":"1178"},{"__attrId":"1199"},{"__attrId":"1220"},{"__attrId":"1241"},{"__exprId":"3814f401-080c-43cf-97b2-06e1c6fe51d0"}]}}]},"attributes":[{"id":"678","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"change_note"},{"id":"679","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"change_time"},{"id":"680","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"commission_id"},{"id":"681","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"create_time"},{"id":"682","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_id"},{"id":"683","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_name"},{"id":"684","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_type"},{"id":"685","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"ip"},{"id":"686","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"is_mobile"},{"id":"687","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_id"},{"id":"688","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_name"},{"id":"689","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"promotion_id"},{"id":"690","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"referer"},{"id":"691","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"status"},{"id":"692","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"sub_id"},{"id":"693","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_commission"},{"id":"694","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_shopping_cart"},{"id":"695","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"tracktype"},{"id":"696","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_source"},{"id":"697","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","name":"look_back_days"},{"id":"698","dataType":"208d3fff-b45a-4f21-a64a-04c2b75d1f11","name":"row_xxhash64"},{"id":"699","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"country_iso"},{"id":"700","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"created"},{"id":"701","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"currency"},{"id":"702","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"from_to"},{"id":"703","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"affiliate_network_id"},{"id":"704","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_id"},{"id":"705","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"unique_id"},{"id":"706","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"partial_update"},{"id":"60","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"change_note"},{"id":"61","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"change_time"},{"id":"62","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"commission_id"},{"id":"63","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"create_time"},{"id":"64","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_id"},{"id":"65","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_name"},{"id":"66","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_type"},{"id":"67","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"ip"},{"id":"68","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"is_mobile"},{"id":"69","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_id"},{"id":"70","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_name"},{"id":"71","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"promotion_id"},{"id":"72","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"referer"},{"id":"73","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"status"},{"id":"74","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"sub_id"},{"id":"75","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_commission"},{"id":"76","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_shopping_cart"},{"id":"77","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"tracktype"},{"id":"78","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_source"},{"id":"79","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","name":"look_back_days"},{"id":"80","dataType":"208d3fff-b45a-4f21-a64a-04c2b75d1f11","name":"row_xxhash64"},{"id":"81","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"country_iso"},{"id":"82","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"created"},{"id":"83","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"currency"},{"id":"84","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"from_to"},{"id":"85","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"affiliate_network_id"},{"id":"86","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_id"},{"id":"87","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"unique_id"},{"id":"88","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"partial_update"},{"id":"199","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"change_note"},{"id":"200","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"change_time"},{"id":"201","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"commission_id"},{"id":"202","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"create_time"},{"id":"203","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_id"},{"id":"204","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_name"},{"id":"205","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_type"},{"id":"206","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"ip"},{"id":"207","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"is_mobile"},{"id":"208","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_id"},{"id":"209","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_name"},{"id":"210","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"promotion_id"},{"id":"211","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"referer"},{"id":"212","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"status"},{"id":"213","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"sub_id"},{"id":"214","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_commission"},{"id":"215","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_shopping_cart"},{"id":"216","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"tracktype"},{"id":"217","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_source"},{"id":"218","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","name":"look_back_days"},{"id":"219","dataType":"208d3fff-b45a-4f21-a64a-04c2b75d1f11","name":"row_xxhash64"},{"id":"220","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"country_iso"},{"id":"221","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"created"},{"id":"222","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"currency"},{"id":"223","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"from_to"},{"id":"224","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"affiliate_network_id"},{"id":"225","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_id"},{"id":"226","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"unique_id"},{"id":"227","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"partial_update"},{"id":"0","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"change_note"},{"id":"1","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"change_time"},{"id":"2","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"commission_id"},{"id":"3","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"create_time"},{"id":"4","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_id"},{"id":"5","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_name"},{"id":"6","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"event_type"},{"id":"7","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"ip"},{"id":"8","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"is_mobile"},{"id":"9","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_id"},{"id":"10","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"program_name"},{"id":"11","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"promotion_id"},{"id":"12","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"referer"},{"id":"13","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"status"},{"id":"14","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"sub_id"},{"id":"15","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_commission"},{"id":"16","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"total_shopping_cart"},{"id":"17","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"tracktype"},{"id":"18","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_source"},{"id":"19","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","name":"look_back_days"},{"id":"20","dataType":"208d3fff-b45a-4f21-a64a-04c2b75d1f11","name":"row_xxhash64"},{"id":"21","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"country_iso"},{"id":"22","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"created"},{"id":"23","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"currency"},{"id":"24","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"from_to"},{"id":"25","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"affiliate_network_id"},{"id":"26","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"transaction_id"},{"id":"27","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"unique_id"},{"id":"28","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"updated"},{"id":"29","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","name":"partial_update"},{"id":"264","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__exprId":"74f65fbf-b8bf-447d-af56-fe911f500776"}],"name":"affiliate_network"},{"id":"123","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"55df7ee0-b739-4034-a68d-2a7188fd8aa5"}],"name":"commission"},{"id":"123","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"addc1cfe-97ce-41a0-96fd-86c5c800a4b1"}],"name":"commission"},{"id":"123","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"d7920062-6d8d-410d-9287-fbd949ca44f5"}],"name":"commission"},{"id":"296","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"cedeb398-25b2-40ae-95d7-a1e55af0e744"}],"name":"time_of_event"},{"id":"591","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"ebbd77d9-232d-4bad-987e-ef0757ddff56"}],"name":"total"},{"id":"591","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"779cc179-2ed8-41c5-8f53-a533b7f8ec1a"}],"name":"total"},{"id":"328","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"9de8a48a-e604-4eea-88f3-c43af1ca758d"}],"name":"clickout_id"},{"id":"599","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"7fbee5ea-8ef2-4e75-bf51-71d95e5258a2"}],"name":"commission"},{"id":"599","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"7de2e81a-7fba-4807-9487-0a77b28db75d"}],"name":"commission"},{"id":"178","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"0a1786d4-1c67-4bfd-ae4a-4c048685f6b8"}],"name":"transaction_status"},{"id":"135","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"00a0c5c8-5d29-4d74-8df7-824877a032e4"}],"name":"total_original"},{"id":"178","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"21e5024e-7a1c-463e-90c4-88788d079d22"}],"name":"transaction_status"},{"id":"361","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"691b6596-7258-4369-87a3-1a9fce3ec811"}],"name":"program_id"},{"id":"607","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"bd5c72a8-d98d-4e0e-b64f-47afff22c934"}],"name":"transaction_status"},{"id":"607","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"04fe3e57-b838-48b6-8423-8c835fad6475"}],"name":"transaction_status"},{"id":"141","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"52bf10da-ffd1-4115-b9b5-406ba9530114"}],"name":"commission_original"},{"id":"394","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"e8420c2b-d62b-4e60-abe5-ab05cd91fe13"}],"name":"commission"},{"id":"428","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"570640a6-db95-4f35-86ce-21703b99258c"}],"name":"transaction_status"},{"id":"662","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"a609e273-9eb4-4aa7-91c9-b297239cf475"}],"name":"previous_commission"},{"id":"663","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"7f567f50-02f9-4603-bba8-ae0e07af34b1"}],"name":"previous_total"},{"id":"463","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"72519f95-643e-49e6-ad5e-1dfeecbd6564"}],"name":"total"},{"id":"151","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"04b783ae-e54f-4cd6-aed5-619afb5fb49e"}],"name":"total_original"},{"id":"187","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"386e2f3f-1226-4225-b376-01734c939278"}],"name":"row_number"},{"id":"499","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"bc2f0b75-85ee-4e37-91eb-ce6b6deef4e0"}],"name":"transaction_type"},{"id":"156","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"b19c6512-dcc5-45c2-b4d2-78c3e5047a5e"}],"name":"commission_original"},{"id":"536","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"84625252-c9d5-433e-bfae-34f93d6a09d5"}],"name":"vp_flag"},{"id":"669","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"5ad81d12-2183-4c96-b2d1-41ac17f7f3ec"}],"name":"row_number"},{"id":"162","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"df78bf2c-5bf2-4fd2-a33d-0ceca2556f8e"}],"name":"row_number"},{"id":"192","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"8a290b0a-6ffa-4367-878c-e5bc2c77d1d3"}],"name":"first_valid_status_date"},{"id":"233","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"4f00c4da-01a1-4a64-a66a-e42fbdab1e2f"}],"name":"previous_transaction_status"},{"id":"716","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"5dc1e339-64c1-42db-bc93-df72462e18c3"}],"name":"previous_commission"},{"id":"726","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"1261bd7a-e79e-49c8-82b8-1bca098a5d40"}],"name":"previous_total"},{"id":"240","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"b817a1b9-3376-4f2c-a81b-16c86913ee66"}],"name":"bi_validated_date"},{"id":"737","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"2aad6e3a-c25b-4fb4-b323-f766428a32a4"}],"name":"row_number"},{"id":"249","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"f7bdfab8-3323-409a-9bf7-33c9e7e4eae1"}],"name":"row_number"},{"id":"776","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"71256fc7-359c-4429-af54-896465c630cb"}],"name":"commission"},{"id":"799","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"c649fcc4-565b-45d3-abd0-0d955f9552bc"}],"name":"total"},{"id":"863","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"1e67f76c-df9a-4b22-a6d0-a07913e2d961"}],"name":"unique_id"},{"id":"884","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"5d5077f4-a04f-4b3f-866d-3c2c984f8d9d"}],"name":"country_iso"},{"id":"905","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"724cfbe5-e797-409e-9858-4b716b274e80"}],"name":"clickout_id"},{"id":"926","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__exprId":"ab789527-973c-43fa-bcb8-308bb3d441d2"}],"name":"affiliate_network"},{"id":"947","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"2264a5ea-bf12-4c9f-99db-1584968c29af"}],"name":"total"},{"id":"968","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"073852da-b3d7-447c-924a-5aad2a5e18b7"}],"name":"program_id"},{"id":"989","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"b955d63c-2bb5-4336-86ac-2beac87316f8"}],"name":"currency"},{"id":"1010","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"4b911110-309f-4394-b044-40e47cbd1cd2"}],"name":"commission"},{"id":"1031","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"5194b68b-7a0b-42a3-84a4-45d42fa1433e"}],"name":"time_of_event"},{"id":"1052","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"59de4722-7560-4148-bc5d-f399f0a2aa56"}],"name":"transaction_type"},{"id":"1073","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"15c4623b-43a0-4582-9a4f-e042d8c0c132"}],"name":"transaction_status"},{"id":"1094","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"e1a3b3cd-eca6-44dc-b0f0-5e0479e0e23d"}],"name":"transaction_id"},{"id":"1115","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"9c386400-1883-47cb-b742-5f2ce22dfe6f"}],"name":"affiliate_network_id"},{"id":"1136","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"4616a7c3-a90e-493e-8d63-2924821b0f22"}],"name":"transaction_source"},{"id":"1157","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"a7e75a99-cc7a-4ae2-9fac-919c7b52582a"}],"name":"created"},{"id":"1178","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"7f4e059b-b887-4518-a94a-9347d5f7d4f6"}],"name":"updated"},{"id":"1199","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"35813355-3089-4674-9d6c-a1598f2e6939"}],"name":"vp_flag"},{"id":"1220","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"fd92a1fd-de36-42de-90ff-9172ac392fd5"}],"name":"total_original"},{"id":"1241","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"e20f05cf-52a9-4927-a006-c8bedad935f4"}],"name":"commission_original"},{"id":"1262","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"9be27bc3-4754-4cbb-89e8-e8b0d4618844"}],"name":"bi_validated_date"},{"id":"1283","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__exprId":"cb523fd2-c05c-4c8d-94fb-b9f50a166a15"}],"name":"affiliate_network"},{"id":"1304","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"3814f401-080c-43cf-97b2-06e1c6fe51d0"}],"name":"bi_validated_date"}],"expressions":{"functions":[{"id":"74f65fbf-b8bf-447d-af56-fe911f500776","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__exprId":"b0a78985-943a-4037-8881-cda41d728a7b"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"affiliate_network","params":{"name":"affiliate_network","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(264,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"bf18a63a-ae58-4daa-a240-4be5f1f5355c","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"693"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"55df7ee0-b739-4034-a68d-2a7188fd8aa5","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"bf18a63a-ae58-4daa-a240-4be5f1f5355c"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(123,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"f758777b-583e-47eb-834a-c52ca3c1f44f","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"75"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"addc1cfe-97ce-41a0-96fd-86c5c800a4b1","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"f758777b-583e-47eb-834a-c52ca3c1f44f"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(123,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a68077c0-9000-4144-952d-14ad47b4485e","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"214"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"d7920062-6d8d-410d-9287-fbd949ca44f5","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"a68077c0-9000-4144-952d-14ad47b4485e"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(123,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"cedeb398-25b2-40ae-95d7-a1e55af0e744","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"3"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"time_of_event","params":{"name":"time_of_event","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(296,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"32d15452-7e8f-4c7f-a6c8-dcc7395055c3","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"694"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"ebbd77d9-232d-4bad-987e-ef0757ddff56","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"32d15452-7e8f-4c7f-a6c8-dcc7395055c3"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total","params":{"name":"total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(591,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a69981a9-1dcd-4d4f-ba54-2f201a1d802b","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"76"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"779cc179-2ed8-41c5-8f53-a533b7f8ec1a","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"a69981a9-1dcd-4d4f-ba54-2f201a1d802b"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total","params":{"name":"total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(591,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"f4e0531d-0a23-4d45-8fd9-86c21c90a6a0","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"14"},{"__exprId":"d0cfc096-b281-435c-bb62-5998a90b0004"},{"__exprId":"85aa44fc-2250-4051-9cdd-5171d9089804"}],"extra":{"simpleClassName":"Substring","_typeHint":"expr.Generic"},"name":"substring"},{"id":"9de8a48a-e604-4eea-88f3-c43af1ca758d","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"f4e0531d-0a23-4d45-8fd9-86c21c90a6a0"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"clickout_id","params":{"name":"clickout_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(328,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"240d7fcc-2db2-4e52-9239-abd74f9b8014","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"693"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"7fbee5ea-8ef2-4e75-bf51-71d95e5258a2","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"240d7fcc-2db2-4e52-9239-abd74f9b8014"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(599,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"29630a3c-287e-4f1d-a415-c5b172593b62","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"75"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"7de2e81a-7fba-4807-9487-0a77b28db75d","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"29630a3c-287e-4f1d-a415-c5b172593b62"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(599,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"53dca036-b1b4-4e66-bf0f-98b62d6d57da","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"73"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"99071a8e-9b32-4cb9-a8f7-8385646f1fff","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"53dca036-b1b4-4e66-bf0f-98b62d6d57da"},{"__exprId":"2e933b29-cdf0-4e88-8693-56386810a939"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"251590ad-fd1b-4b7e-8908-7f2f6c8fc0fb","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"53dca036-b1b4-4e66-bf0f-98b62d6d57da"},{"__exprId":"36db5e5a-ccd5-4820-89b2-1088c6e1e62a"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"b1f35f01-9d33-4929-95aa-5cd5254a9c74","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"53dca036-b1b4-4e66-bf0f-98b62d6d57da"},{"__exprId":"4d52f8e7-3a6d-4e1f-b80c-35a3b54a6952"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"05708610-6b3e-4107-bf44-6e482081c392","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"b1f35f01-9d33-4929-95aa-5cd5254a9c74"},{"__exprId":"794349e4-8a93-4ecd-86d4-b34fe9361be7"},{"__exprId":"2d936cc4-7275-4d37-8a2b-0f1c1d1eaacd"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = cancelled),Refused)"],"elseValue":"null"}},{"id":"2bb06aac-e843-4e5a-abf3-00c8b0c46ace","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"251590ad-fd1b-4b7e-8908-7f2f6c8fc0fb"},{"__exprId":"29b8329b-73c2-4c7e-809b-c26396f7a8dd"},{"__exprId":"05708610-6b3e-4107-bf44-6e482081c392"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = open),Pending)"],"elseValue":"CASE WHEN (lower(status#73) = cancelled) THEN Refused ELSE null END"}},{"id":"162b8f35-027a-4779-bb85-5f2344475da7","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"99071a8e-9b32-4cb9-a8f7-8385646f1fff"},{"__exprId":"4db7d5f7-f2d5-4d33-887f-c9a215cb8009"},{"__exprId":"2bb06aac-e843-4e5a-abf3-00c8b0c46ace"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = accepted),Validated)"],"elseValue":"CASE WHEN (lower(status#73) = open) THEN Pending ELSE CASE WHEN (lower(status#73) = cancelled) THEN Refused ELSE null END END"}},{"id":"0a1786d4-1c67-4bfd-ae4a-4c048685f6b8","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"162b8f35-027a-4779-bb85-5f2344475da7"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(178,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"00a0c5c8-5d29-4d74-8df7-824877a032e4","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"76"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total_original","params":{"name":"total_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(135,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"0a285915-75e6-4eab-9db2-e5448d328733","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"212"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"6b9eefd0-a527-4be1-9835-1a39b18e6e0e","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0a285915-75e6-4eab-9db2-e5448d328733"},{"__exprId":"818e4a68-6a2e-4925-9f8d-6d8c9701dc41"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"30843c3d-d8b0-4cd1-94b6-e82d5a0822a1","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0a285915-75e6-4eab-9db2-e5448d328733"},{"__exprId":"85b36c0d-a4e1-4325-9a58-fa047a6dfba3"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"18099536-9f33-47a3-8498-d22e86cccbfe","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0a285915-75e6-4eab-9db2-e5448d328733"},{"__exprId":"67b6accb-c8f1-4dcb-b80c-ebe2699cb954"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"f6115289-3470-4778-81f3-773720631e0a","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"18099536-9f33-47a3-8498-d22e86cccbfe"},{"__exprId":"5022e25e-0f3c-453b-9beb-ff2af5b9e993"},{"__exprId":"9b278aec-00c1-4c2d-a6ec-0a8fd525c366"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#212) = cancelled),Refused)"],"elseValue":"null"}},{"id":"1e4c68c5-c1e5-45e0-bd18-194c40d8bad5","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"30843c3d-d8b0-4cd1-94b6-e82d5a0822a1"},{"__exprId":"651e2c14-aaca-432a-b531-a22886cea8d1"},{"__exprId":"f6115289-3470-4778-81f3-773720631e0a"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#212) = open),Pending)"],"elseValue":"CASE WHEN (lower(status#212) = cancelled) THEN Refused ELSE null END"}},{"id":"91967bf0-c77e-4fee-980b-f46a1a6cf1b2","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"6b9eefd0-a527-4be1-9835-1a39b18e6e0e"},{"__exprId":"93535947-8e6b-45d3-8b98-cafb40553730"},{"__exprId":"1e4c68c5-c1e5-45e0-bd18-194c40d8bad5"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#212) = accepted),Validated)"],"elseValue":"CASE WHEN (lower(status#212) = open) THEN Pending ELSE CASE WHEN (lower(status#212) = cancelled) THEN Refused ELSE null END END"}},{"id":"21e5024e-7a1c-463e-90c4-88788d079d22","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"91967bf0-c77e-4fee-980b-f46a1a6cf1b2"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(178,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"64b290c7-7d4c-4644-aa2c-134032e9a254","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"10"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"148776a5-e82b-43a0-a42d-f7459cc4cc28","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"10"},{"__exprId":"c59f73ac-8b4e-44fb-9f22-189e30cd889b"}],"extra":{"simpleClassName":"StringTrim","_typeHint":"expr.Generic"},"name":"trim","params":{"trimStr":" \t\n\r"}},{"id":"05fd495c-31a2-488e-9158-3be2bb71c94f","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"148776a5-e82b-43a0-a42d-f7459cc4cc28"},{"__exprId":"bedc75d2-c192-4820-b5eb-a5ac5adb04a7"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"bc7f76ed-3342-4b9d-a4f9-9d6347113493","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"05fd495c-31a2-488e-9158-3be2bb71c94f"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"65d8ca85-e4a3-4056-8c5d-e2914b0a4e06","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"64b290c7-7d4c-4644-aa2c-134032e9a254"},{"__exprId":"bc7f76ed-3342-4b9d-a4f9-9d6347113493"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"2057e356-ac51-422a-9214-c8d94a5dcb88","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"9"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"a6c59d64-0baf-487f-a76a-b56934775430","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"9"},{"__exprId":"c59f73ac-8b4e-44fb-9f22-189e30cd889b"}],"extra":{"simpleClassName":"StringTrim","_typeHint":"expr.Generic"},"name":"trim","params":{"trimStr":" \t\n\r"}},{"id":"caf1c21e-7533-4d3a-98df-c79d43abc54f","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"a6c59d64-0baf-487f-a76a-b56934775430"},{"__exprId":"bedc75d2-c192-4820-b5eb-a5ac5adb04a7"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"a9629ae1-ff4e-4280-abcc-4d79a9118092","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"caf1c21e-7533-4d3a-98df-c79d43abc54f"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"86c9a5ed-55dc-4ce0-a2ee-61d3cef4526b","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"2057e356-ac51-422a-9214-c8d94a5dcb88"},{"__exprId":"a9629ae1-ff4e-4280-abcc-4d79a9118092"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"6dde70a8-d042-4d27-bb2c-c177a98ff97d","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"86c9a5ed-55dc-4ce0-a2ee-61d3cef4526b"},{"__attrId":"9"},{"__exprId":"2452b137-5bdd-4a88-95ff-330d4af2ae7c"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((isnotnull(program_id#9) AND NOT (trim(program_id#9, Some( \t\n\r)) = )),program_id#9)"],"elseValue":"null"}},{"id":"dde2ab55-7c99-4bad-a0ca-d97af79d5ad2","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"65d8ca85-e4a3-4056-8c5d-e2914b0a4e06"},{"__attrId":"10"},{"__exprId":"6dde70a8-d042-4d27-bb2c-c177a98ff97d"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((isnotnull(program_name#10) AND NOT (trim(program_name#10, Some( \t\n\r)) = )),program_name#10)"],"elseValue":"CASE WHEN (isnotnull(program_id#9) AND NOT (trim(program_id#9, Some( \t\n\r)) = )) THEN program_id#9 ELSE null END"}},{"id":"691b6596-7258-4369-87a3-1a9fce3ec811","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"dde2ab55-7c99-4bad-a0ca-d97af79d5ad2"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"program_id","params":{"name":"program_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(361,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"67125ffc-46c3-4da7-80f6-ad0cc6d52578","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"691"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"d068fe28-890d-4c4c-be4d-73d178d2e504","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"67125ffc-46c3-4da7-80f6-ad0cc6d52578"},{"__exprId":"80cc3b18-b214-46cd-8e95-6fbcfa2cad0c"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"9b37f8c5-4ee9-491e-948a-cda438591e26","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"67125ffc-46c3-4da7-80f6-ad0cc6d52578"},{"__exprId":"3da37baa-8c6a-4f3a-afbf-ddfad82057c3"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"dda0095a-3037-4a4c-a93e-c2cd6b4a7bf7","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"67125ffc-46c3-4da7-80f6-ad0cc6d52578"},{"__exprId":"7d2523a1-8944-469a-b299-f5bee631bb85"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"06d044e2-534c-4756-8d66-6a1409eb9cef","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"dda0095a-3037-4a4c-a93e-c2cd6b4a7bf7"},{"__exprId":"14a5a040-5e0d-4150-99ac-a6fe0e087c74"},{"__exprId":"be1109d0-e6c1-4646-8a8d-9a86bc3cae29"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#691) = cancelled),Refused)"],"elseValue":"null"}},{"id":"e348668c-07e2-4448-9f76-2e81b58699f9","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"9b37f8c5-4ee9-491e-948a-cda438591e26"},{"__exprId":"c356439e-1df0-4718-9756-5b7503130697"},{"__exprId":"06d044e2-534c-4756-8d66-6a1409eb9cef"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#691) = open),Pending)"],"elseValue":"CASE WHEN (lower(status#691) = cancelled) THEN Refused ELSE null END"}},{"id":"45a04ee5-d40f-4ecf-a6da-43399d8ffb32","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"d068fe28-890d-4c4c-be4d-73d178d2e504"},{"__exprId":"b156da56-2c67-4046-a08e-0b30d04803c2"},{"__exprId":"e348668c-07e2-4448-9f76-2e81b58699f9"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#691) = accepted),Validated)"],"elseValue":"CASE WHEN (lower(status#691) = open) THEN Pending ELSE CASE WHEN (lower(status#691) = cancelled) THEN Refused ELSE null END END"}},{"id":"bd5c72a8-d98d-4e0e-b64f-47afff22c934","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"45a04ee5-d40f-4ecf-a6da-43399d8ffb32"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(607,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a30a517b-042e-4678-8b52-19a47bbbe0e3","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"73"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"5298dfa8-58db-4f20-a71d-6893c2e38391","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"a30a517b-042e-4678-8b52-19a47bbbe0e3"},{"__exprId":"2972cb2e-d2ec-4548-a777-a066a56ae0d4"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"e66a190b-95d4-4228-b117-f9a62a1c24f5","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"a30a517b-042e-4678-8b52-19a47bbbe0e3"},{"__exprId":"f4a6d03d-ae3d-4311-86b5-9f7f96157f75"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"ae642b5c-665a-4c9c-aea1-b43e066e6633","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"a30a517b-042e-4678-8b52-19a47bbbe0e3"},{"__exprId":"3744b8a3-7aee-4f54-a329-bd703fd645f3"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"6b4b7756-ac6a-47c8-bfc6-3e7742cff4d2","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"ae642b5c-665a-4c9c-aea1-b43e066e6633"},{"__exprId":"1ffdd9d8-083a-4386-b509-0be134ccf7b3"},{"__exprId":"8aa1aa07-a42d-4502-b4e4-935b0a59b16a"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = cancelled),Refused)"],"elseValue":"null"}},{"id":"5201e200-a514-496b-be71-d929c2659ca4","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"e66a190b-95d4-4228-b117-f9a62a1c24f5"},{"__exprId":"6c0ff076-3107-4615-9ba3-2d222035a5d5"},{"__exprId":"6b4b7756-ac6a-47c8-bfc6-3e7742cff4d2"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = open),Pending)"],"elseValue":"CASE WHEN (lower(status#73) = cancelled) THEN Refused ELSE null END"}},{"id":"803aeb2b-5e49-4628-b02b-77c2c6e4d7ef","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"5298dfa8-58db-4f20-a71d-6893c2e38391"},{"__exprId":"c566e6c8-fd0a-4121-8c15-3356815bdf91"},{"__exprId":"5201e200-a514-496b-be71-d929c2659ca4"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#73) = accepted),Validated)"],"elseValue":"CASE WHEN (lower(status#73) = open) THEN Pending ELSE CASE WHEN (lower(status#73) = cancelled) THEN Refused ELSE null END END"}},{"id":"04fe3e57-b838-48b6-8423-8c835fad6475","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"803aeb2b-5e49-4628-b02b-77c2c6e4d7ef"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(607,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"52bf10da-ffd1-4115-b9b5-406ba9530114","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"75"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission_original","params":{"name":"commission_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(141,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"b774579b-3383-4e6a-8314-fb6304e00f86","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"15"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"e8420c2b-d62b-4e60-abe5-ab05cd91fe13","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"b774579b-3383-4e6a-8314-fb6304e00f86"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(394,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"7df8977a-d0f5-4be9-beeb-28f242e4a278","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"135"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"bce01be0-6edf-4af5-9ac8-8527c82c8e85","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"135"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"1e1f6a53-daf6-4acf-bf84-6f8cc7835ced","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"bce01be0-6edf-4af5-9ac8-8527c82c8e85"},{"__exprId":"5989c344-750c-4167-9c54-835d6aab5e95"}],"extra":{"simpleClassName":"StringTrim","_typeHint":"expr.Generic"},"name":"trim","params":{"trimStr":" \t\n\r"}},{"id":"a7ba3829-2b8f-411f-a088-16bf4fa7c34c","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"1e1f6a53-daf6-4acf-bf84-6f8cc7835ced"},{"__exprId":"fecfe53e-96a4-4ada-bdea-335ed59392d2"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"ebc7e3a6-e51c-43e9-9868-95ab89de9de7","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"a7ba3829-2b8f-411f-a088-16bf4fa7c34c"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"fb266394-9a53-4452-8635-3735fecfa948","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"7df8977a-d0f5-4be9-beeb-28f242e4a278"},{"__exprId":"ebc7e3a6-e51c-43e9-9868-95ab89de9de7"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"9b3f2b32-2655-4f72-a861-bb00b7e87035","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"141"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"bea2c5d2-a140-420b-9707-7754843e6b03","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"141"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"ef083a8f-b255-441c-b8a8-84a01af5dc44","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"bea2c5d2-a140-420b-9707-7754843e6b03"},{"__exprId":"5989c344-750c-4167-9c54-835d6aab5e95"}],"extra":{"simpleClassName":"StringTrim","_typeHint":"expr.Generic"},"name":"trim","params":{"trimStr":" \t\n\r"}},{"id":"f6a83348-4319-4479-a6bb-7ba87b41cc12","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"ef083a8f-b255-441c-b8a8-84a01af5dc44"},{"__exprId":"fecfe53e-96a4-4ada-bdea-335ed59392d2"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"92c18d79-8ede-4f3d-abea-096b56dbbdb5","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"f6a83348-4319-4479-a6bb-7ba87b41cc12"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"5d51c9ca-7e62-48af-970f-e007c64e1369","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"9b3f2b32-2655-4f72-a861-bb00b7e87035"},{"__exprId":"92c18d79-8ede-4f3d-abea-096b56dbbdb5"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"9117093a-a031-40e5-924c-3b1ab7bc01d5","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"fb266394-9a53-4452-8635-3735fecfa948"},{"__exprId":"5d51c9ca-7e62-48af-970f-e007c64e1369"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"97f29f92-18e2-4d51-b98f-2b9cd8301900","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"178"},{"__exprId":"69cd10dc-3f1b-401b-8243-7f38eacb4cb1"},{"__exprId":"53b22c18-c0bf-4b62-b970-682e4250e042"}],"extra":{"simpleClassName":"In","_typeHint":"expr.Generic"},"name":"in","params":{"list":["Paid","Validated"]}},{"id":"2cc3906c-1cf3-44b1-9bfa-77d88ecf69d0","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"13"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"acd816b8-16f0-41ee-a281-0c3759e86466","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"2cc3906c-1cf3-44b1-9bfa-77d88ecf69d0"},{"__exprId":"0b35c07c-1c09-48c3-83b0-f9aa558a60ae"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"a7d58f6f-b9db-4642-9a25-25c9d5722ce2","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"2cc3906c-1cf3-44b1-9bfa-77d88ecf69d0"},{"__exprId":"40e36e2a-c23c-404b-a15d-817e5675b6d2"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"a2d79cff-97d7-4f68-820f-95c95c80dc17","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"2cc3906c-1cf3-44b1-9bfa-77d88ecf69d0"},{"__exprId":"870ba440-65b7-4244-861d-7cb8c15d99fb"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"85e7f3bd-9110-4829-a1a2-054444abfe09","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"a2d79cff-97d7-4f68-820f-95c95c80dc17"},{"__exprId":"850e3681-759a-4d5b-8ea6-c099c9c345a4"},{"__exprId":"7c25e41d-23cb-44a8-adc0-17d0edfa88f0"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#13) = cancelled),Refused)"],"elseValue":"null"}},{"id":"98d00b0d-26f4-4e10-ab40-947d33fb0579","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"a7d58f6f-b9db-4642-9a25-25c9d5722ce2"},{"__exprId":"91641846-d21e-4e7a-8a67-bdd157b5ad67"},{"__exprId":"85e7f3bd-9110-4829-a1a2-054444abfe09"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#13) = open),Pending)"],"elseValue":"CASE WHEN (lower(status#13) = cancelled) THEN Refused ELSE null END"}},{"id":"e53ba27f-5617-404b-ae93-86ea103c2ffe","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"acd816b8-16f0-41ee-a281-0c3759e86466"},{"__exprId":"c571faee-cb84-4ca3-91fe-968d62a6b9d0"},{"__exprId":"98d00b0d-26f4-4e10-ab40-947d33fb0579"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(status#13) = accepted),Validated)"],"elseValue":"CASE WHEN (lower(status#13) = open) THEN Pending ELSE CASE WHEN (lower(status#13) = cancelled) THEN Refused ELSE null END END"}},{"id":"570640a6-db95-4f35-86ce-21703b99258c","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"e53ba27f-5617-404b-ae93-86ea103c2ffe"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(428,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a609e273-9eb4-4aa7-91c9-b297239cf475","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"599"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"previous_commission","params":{"name":"previous_commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(662,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"7f567f50-02f9-4603-bba8-ae0e07af34b1","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"591"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"previous_total","params":{"name":"previous_total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(663,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"39b211e6-b9b2-4647-aa76-acfb88b711cc","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"607"},{"__exprId":"724a267f-1209-4668-b29c-897a53676a4d"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"01aae5ae-4e71-41a5-a9b3-cba864a086d5","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"16"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"72519f95-643e-49e6-ad5e-1dfeecbd6564","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"01aae5ae-4e71-41a5-a9b3-cba864a086d5"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total","params":{"name":"total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(463,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"c37cfa5e-e88b-4b57-a508-1030971a8ce5","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"607"},{"__exprId":"6a42fc85-54aa-48f7-8113-2879ac58171d"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"98cb1724-e454-4bfe-a8ee-3c585aa0fac2","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"c37cfa5e-e88b-4b57-a508-1030971a8ce5"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"bbe96524-b2a5-44c8-95ed-9e9908f811ed","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"135"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"04b783ae-e54f-4cd6-aed5-619afb5fb49e","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"bbe96524-b2a5-44c8-95ed-9e9908f811ed"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total_original","params":{"name":"total_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(151,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"8f37278d-9016-4ef4-8c06-9b91b257cb05","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"RowNumber","_typeHint":"expr.Generic"},"name":"row_number"},{"id":"e6b97762-e9a9-4448-ad33-f98cba6994ab","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"221"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Ascending","nullOrdering":"NullsFirst"}},{"id":"f2f7514c-4000-4306-b81d-bb1b1ff58812","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"UnboundedPreceding$","_typeHint":"expr.Generic"},"name":"unboundedpreceding$"},{"id":"106a9825-b57c-47a8-935c-e2e67e4de27c","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"CurrentRow$","_typeHint":"expr.Generic"},"name":"currentrow$"},{"id":"0d27abb0-3163-40a9-a8c1-b49eddf0fe01","childRefs":[{"__exprId":"f2f7514c-4000-4306-b81d-bb1b1ff58812"},{"__exprId":"106a9825-b57c-47a8-935c-e2e67e4de27c"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"fae841b1-f29f-437c-ad09-8d5e54ce6fc2","childRefs":[{"__attrId":"226"},{"__exprId":"e6b97762-e9a9-4448-ad33-f98cba6994ab"},{"__exprId":"0d27abb0-3163-40a9-a8c1-b49eddf0fe01"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#226"],"orderSpec":["created#221 ASC NULLS FIRST"]}},{"id":"dd6b6394-baa5-47a2-a6ca-718f7aae27ca","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"8f37278d-9016-4ef4-8c06-9b91b257cb05"},{"__exprId":"fae841b1-f29f-437c-ad09-8d5e54ce6fc2"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"386e2f3f-1226-4225-b376-01734c939278","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"dd6b6394-baa5-47a2-a6ca-718f7aae27ca"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"row_number","params":{"name":"row_number","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(187,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"9296c1c9-f31c-425c-8a9a-48dbd347f53c","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"6"}],"extra":{"simpleClassName":"Lower","_typeHint":"expr.Generic"},"name":"lower"},{"id":"21564bf1-c836-4575-8750-72b44f47b862","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"9296c1c9-f31c-425c-8a9a-48dbd347f53c"},{"__exprId":"20f48cae-bee5-4cfa-b281-c07b5b249cbb"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"9fee6074-4326-459f-9543-7c7dd366764f","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"9296c1c9-f31c-425c-8a9a-48dbd347f53c"},{"__exprId":"d4718826-bc7b-4bba-86a5-292b80631422"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"22b88cc6-cda4-465c-bcd3-2fd29024449a","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"9fee6074-4326-459f-9543-7c7dd366764f"},{"__exprId":"c8f2fe4f-9a78-43a6-99a6-8d4a8967d4c7"},{"__exprId":"3f1ac1f0-1932-4319-8e73-2c472cacd0b3"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(event_type#6) = lead),Lead)"],"elseValue":"null"}},{"id":"450e3cad-1393-458b-8a95-cd7dbfc925e3","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"21564bf1-c836-4575-8750-72b44f47b862"},{"__exprId":"67e0885e-e4fd-4d57-9ff7-c377c91703ab"},{"__exprId":"22b88cc6-cda4-465c-bcd3-2fd29024449a"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((lower(event_type#6) = sale),Sale)"],"elseValue":"CASE WHEN (lower(event_type#6) = lead) THEN Lead ELSE null END"}},{"id":"bc2f0b75-85ee-4e37-91eb-ce6b6deef4e0","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"450e3cad-1393-458b-8a95-cd7dbfc925e3"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_type","params":{"name":"transaction_type","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(499,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"2326f2e8-a0f6-4c3b-b62c-10baa52fa06a","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"141"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"b19c6512-dcc5-45c2-b4d2-78c3e5047a5e","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"2326f2e8-a0f6-4c3b-b62c-10baa52fa06a"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission_original","params":{"name":"commission_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(156,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"f92aca34-88a7-48d3-8431-2c5ee89575f9","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__attrId":"328"}],"extra":{"simpleClassName":"Length","_typeHint":"expr.Generic"},"name":"length"},{"id":"67591d3d-5738-4891-856c-d35dcb50a5f4","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"f92aca34-88a7-48d3-8431-2c5ee89575f9"},{"__exprId":"2593968a-9c06-4463-8199-9c511a3fa6f0"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"be7b5d51-9a95-49d7-bc87-38ea0e46dc7d","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"328"},{"__exprId":"21b44c2a-0b84-4b90-a4a8-160c5d89763e"},{"__exprId":"f97722da-3ed9-44f9-a49a-ac4b37ceb097"}],"extra":{"simpleClassName":"Substring","_typeHint":"expr.Generic"},"name":"substring"},{"id":"5fffd7af-81ab-44fc-b957-ed0fea5c0511","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"be7b5d51-9a95-49d7-bc87-38ea0e46dc7d"},{"__exprId":"4c052b2d-2563-4fd3-ae5c-28a6a4570c72"},{"__exprId":"976f442c-2da8-400b-b499-b6c860418b4e"},{"__exprId":"65acbda2-9d6f-4a06-9b7b-401cec00b8ba"},{"__exprId":"771bb9ad-8f41-4fa2-b2da-29f32c1741fc"},{"__exprId":"280b2f61-f3c2-4661-ba6a-3fd3ddd6886a"},{"__exprId":"8981fd54-0d7a-4db2-ab75-37c1da25afa6"},{"__exprId":"8edd88d5-cb30-45cc-8c2a-536f0f1d4911"}],"extra":{"simpleClassName":"In","_typeHint":"expr.Generic"},"name":"in","params":{"list":["cn","wl","dl","ps","sp","la","cd"]}},{"id":"c6cf8b26-4521-4b21-b64c-f507d9edce8b","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"67591d3d-5738-4891-856c-d35dcb50a5f4"},{"__exprId":"5fffd7af-81ab-44fc-b957-ed0fea5c0511"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"e2104b6a-c26c-469e-84c7-4997d924d4bf","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"499"},{"__exprId":"0d69c446-cdd6-438a-a94b-55ccbdebf049"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"e486fcf0-c413-4182-a20c-c768da990abe","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"e2104b6a-c26c-469e-84c7-4997d924d4bf"},{"__exprId":"21b44c2a-0b84-4b90-a4a8-160c5d89763e"},{"__exprId":"8c0b558d-5693-4c18-9c7d-e6dc0156cb92"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((transaction_type#499 = extras),1)"],"elseValue":"null"}},{"id":"aff9607f-d7b2-4bf3-b208-3b6d1175800d","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"c6cf8b26-4521-4b21-b64c-f507d9edce8b"},{"__exprId":"7da6d60b-f079-4a40-868e-c7d1baf1a2ee"},{"__exprId":"e486fcf0-c413-4182-a20c-c768da990abe"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["(((length(clickout_id#328) = 42) AND substring(clickout_id#328, 1, 2) IN (cn,wl,dl,ps,sp,la,cd)),0)"],"elseValue":"CASE WHEN (transaction_type#499 = extras) THEN 1 ELSE null END"}},{"id":"84625252-c9d5-433e-bfae-34f93d6a09d5","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"aff9607f-d7b2-4bf3-b208-3b6d1175800d"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"vp_flag","params":{"name":"vp_flag","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(536,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"5bc4a492-c19a-41a3-8936-8a9b47cc04ad","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"RowNumber","_typeHint":"expr.Generic"},"name":"row_number"},{"id":"8a41cbc5-9049-4f43-847b-b6eb1470c1cb","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"700"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Descending","nullOrdering":"NullsLast"}},{"id":"66ea8ef3-b7d1-4e87-a4d3-1ad3d816da14","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"UnboundedPreceding$","_typeHint":"expr.Generic"},"name":"unboundedpreceding$"},{"id":"e8347112-7681-4dae-95c2-bc4ac26f636d","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"CurrentRow$","_typeHint":"expr.Generic"},"name":"currentrow$"},{"id":"c5980187-9c11-497e-bfc9-f2fd23de11c3","childRefs":[{"__exprId":"66ea8ef3-b7d1-4e87-a4d3-1ad3d816da14"},{"__exprId":"e8347112-7681-4dae-95c2-bc4ac26f636d"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"e1f7b17f-47ee-47f1-ae40-31558b2d04f4","childRefs":[{"__attrId":"705"},{"__exprId":"8a41cbc5-9049-4f43-847b-b6eb1470c1cb"},{"__exprId":"c5980187-9c11-497e-bfc9-f2fd23de11c3"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#705"],"orderSpec":["created#700 DESC NULLS LAST"]}},{"id":"683caa70-4dca-4358-a3d3-5700b785bb69","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"5bc4a492-c19a-41a3-8936-8a9b47cc04ad"},{"__exprId":"e1f7b17f-47ee-47f1-ae40-31558b2d04f4"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"5ad81d12-2183-4c96-b2d1-41ac17f7f3ec","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"683caa70-4dca-4358-a3d3-5700b785bb69"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"row_number","params":{"name":"row_number","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(669,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"f66973ac-9416-4d05-bb1b-0148f05a805a","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"RowNumber","_typeHint":"expr.Generic"},"name":"row_number"},{"id":"41affe9c-2ec6-486e-9b24-19edf68871ee","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"82"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Ascending","nullOrdering":"NullsFirst"}},{"id":"5d777222-3969-483b-b107-316b2ed5ea87","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"UnboundedPreceding$","_typeHint":"expr.Generic"},"name":"unboundedpreceding$"},{"id":"1ce98b9c-e014-48bf-8d4e-ba3e93dd2e2f","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"CurrentRow$","_typeHint":"expr.Generic"},"name":"currentrow$"},{"id":"48589fea-2a15-4bb2-9bf6-1872c73af76d","childRefs":[{"__exprId":"5d777222-3969-483b-b107-316b2ed5ea87"},{"__exprId":"1ce98b9c-e014-48bf-8d4e-ba3e93dd2e2f"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"362d840a-0b3e-4334-b1df-4b8a47a0fb21","childRefs":[{"__attrId":"87"},{"__exprId":"41affe9c-2ec6-486e-9b24-19edf68871ee"},{"__exprId":"48589fea-2a15-4bb2-9bf6-1872c73af76d"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#87"],"orderSpec":["created#82 ASC NULLS FIRST"]}},{"id":"f2426900-7b70-427d-b275-141eb4ffb074","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"f66973ac-9416-4d05-bb1b-0148f05a805a"},{"__exprId":"362d840a-0b3e-4334-b1df-4b8a47a0fb21"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"df78bf2c-5bf2-4fd2-a33d-0ceca2556f8e","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"f2426900-7b70-427d-b275-141eb4ffb074"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"row_number","params":{"name":"row_number","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(162,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"9fddbf16-d667-444d-bad6-a554b463cbbb","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"187"},{"__exprId":"306b7292-e648-4719-8018-6dd9de4ef3b5"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"8a290b0a-6ffa-4367-878c-e5bc2c77d1d3","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"221"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"first_valid_status_date","params":{"name":"first_valid_status_date","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(192,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"718469ab-993e-4bf9-aa88-65298a7adbd3","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"669"},{"__exprId":"cb45f640-e35e-4977-9025-643f53e4612f"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"fd7a011d-f287-4bf6-9566-a009f549d213","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"162"},{"__exprId":"b89fb3d4-7447-48a5-9b12-86ef999bd98c"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"fbcc6b8a-561c-44fb-9e0c-80490a8a2fd9","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"87"},{"__attrId":"226"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"7b317665-569f-4be8-bfd3-13c04d980c77","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"87"},{"__attrId":"705"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"bf11ca22-bc33-40db-aafb-6fa0a58f408d","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"27"},{"__attrId":"87"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"1b380761-b466-412c-8d2e-c67c69cfe398","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"178"},{"__exprId":"8d15dd62-95d8-47a2-baa9-38376ea01c5a"},{"__exprId":"b63ca2b3-25b9-4a67-93fd-07f8d5d95103"}],"extra":{"simpleClassName":"Lag","_typeHint":"expr.Generic"},"name":"lag"},{"id":"093db6ff-8350-49cd-82b7-dd04cf124112","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"82"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Ascending","nullOrdering":"NullsFirst"}},{"id":"a2f549bc-0785-4a67-b32c-cbbc66c7726c","childRefs":[{"__exprId":"7aea1ea3-2fe0-47c6-827e-efb77e42c94f"},{"__exprId":"7aea1ea3-2fe0-47c6-827e-efb77e42c94f"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"22b1131f-4c72-4667-a7c4-d0a6a336b680","childRefs":[{"__attrId":"87"},{"__exprId":"093db6ff-8350-49cd-82b7-dd04cf124112"},{"__exprId":"a2f549bc-0785-4a67-b32c-cbbc66c7726c"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#87"],"orderSpec":["created#82 ASC NULLS FIRST"]}},{"id":"d5ef8b2d-b775-427d-b824-9425309e994f","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"1b380761-b466-412c-8d2e-c67c69cfe398"},{"__exprId":"22b1131f-4c72-4667-a7c4-d0a6a336b680"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"4f00c4da-01a1-4a64-a66a-e42fbdab1e2f","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__exprId":"d5ef8b2d-b775-427d-b824-9425309e994f"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"previous_transaction_status","params":{"name":"previous_transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(233,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"6ffbb496-e568-4794-8362-1c4004cee0c9","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"599"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"f82d606f-36f9-4113-a1de-a1198ac2b4df","dataType":"8db3d235-3641-4d3e-91b8-263b9d02bf6e","childRefs":[{"__exprId":"d8a40522-6fbf-49fc-b7a6-34333dbe1555"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"3897f0e5-90d8-4c29-bd6d-22f947d2f499","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"f82d606f-36f9-4113-a1de-a1198ac2b4df"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"f445c7a1-489c-4a2d-aa28-a029177e7c29","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"6ffbb496-e568-4794-8362-1c4004cee0c9"},{"__exprId":"3897f0e5-90d8-4c29-bd6d-22f947d2f499"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"72ad7517-8a03-4c8d-b464-693bfc116f7e","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"662"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"009dda8e-bd7d-45fe-a78b-b6516b92c6cd","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"f445c7a1-489c-4a2d-aa28-a029177e7c29"},{"__exprId":"72ad7517-8a03-4c8d-b464-693bfc116f7e"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"a1b1b89d-e007-433c-a9d0-4ab6f52cf19f","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"009dda8e-bd7d-45fe-a78b-b6516b92c6cd"},{"__attrId":"662"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["(((cast(commission#599 as decimal(19,3)) = cast(cast(0 as decimal(1,0)) as decimal(19,3))) AND isnotnull(previous_commission#662)),previous_commission#662)"]}},{"id":"5dc1e339-64c1-42db-bc93-df72462e18c3","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"a1b1b89d-e007-433c-a9d0-4ab6f52cf19f"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"previous_commission","params":{"name":"previous_commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(716,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"3b14bfa7-9f33-4db9-b20a-3d3059be103f","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"591"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"ac259996-945a-406f-9385-2c90b4b8783c","dataType":"8db3d235-3641-4d3e-91b8-263b9d02bf6e","childRefs":[{"__exprId":"f8e5d6e1-72f8-4650-9a7e-2713d76618f6"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"0778150b-c2a6-463b-bd55-9bf7ead65acc","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"ac259996-945a-406f-9385-2c90b4b8783c"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"c0ab352e-c406-4b1b-8a1a-8884cca55261","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"3b14bfa7-9f33-4db9-b20a-3d3059be103f"},{"__exprId":"0778150b-c2a6-463b-bd55-9bf7ead65acc"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"0006ac85-068f-4034-8921-acebc5f4046d","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"663"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"b7702034-1204-4e6f-b955-e4305c128c26","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"c0ab352e-c406-4b1b-8a1a-8884cca55261"},{"__exprId":"0006ac85-068f-4034-8921-acebc5f4046d"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"96ebadc0-d92d-4fb2-8dea-329c16cc36fb","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"b7702034-1204-4e6f-b955-e4305c128c26"},{"__attrId":"663"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["(((cast(total#591 as decimal(19,3)) = cast(cast(0 as decimal(1,0)) as decimal(19,3))) AND isnotnull(previous_total#663)),previous_total#663)"]}},{"id":"1261bd7a-e79e-49c8-82b8-1bca098a5d40","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"96ebadc0-d92d-4fb2-8dea-329c16cc36fb"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"previous_total","params":{"name":"previous_total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(726,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"0853c8e4-a3d7-44b0-b231-da7e0746f984","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"233"},{"__exprId":"10aae182-d836-4ad4-adfe-a36e2e6e6713"},{"__exprId":"b3a5f1d9-fd93-4cee-b99b-951f55ab910f"}],"extra":{"simpleClassName":"In","_typeHint":"expr.Generic"},"name":"in","params":{"list":["Paid","Validated"]}},{"id":"6d32a1f3-29af-4695-82c8-d6dddd97c0c5","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0853c8e4-a3d7-44b0-b231-da7e0746f984"}],"extra":{"simpleClassName":"Not","_typeHint":"expr.Generic"},"name":"not"},{"id":"521a0c3e-7627-46cd-8953-754beb1b3077","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"233"}],"extra":{"simpleClassName":"IsNull","_typeHint":"expr.Generic"},"name":"isnull"},{"id":"864a027c-3261-419e-8269-74efb4bdef80","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"6d32a1f3-29af-4695-82c8-d6dddd97c0c5"},{"__exprId":"521a0c3e-7627-46cd-8953-754beb1b3077"}],"extra":{"simpleClassName":"Or","_typeHint":"expr.Binary","symbol":"||"},"name":"or"},{"id":"50c0b2be-714b-422f-8154-5baee5ad8f33","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"178"},{"__exprId":"10aae182-d836-4ad4-adfe-a36e2e6e6713"},{"__exprId":"b3a5f1d9-fd93-4cee-b99b-951f55ab910f"}],"extra":{"simpleClassName":"In","_typeHint":"expr.Generic"},"name":"in","params":{"list":["Paid","Validated"]}},{"id":"6be35c7c-083d-4cd5-a5ba-a6f4c4d8ad7b","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"864a027c-3261-419e-8269-74efb4bdef80"},{"__exprId":"50c0b2be-714b-422f-8154-5baee5ad8f33"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"e4347211-7266-42a5-9f94-157e05b5c998","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0853c8e4-a3d7-44b0-b231-da7e0746f984"},{"__exprId":"50c0b2be-714b-422f-8154-5baee5ad8f33"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"bd881d93-e905-4d89-ab9c-cc68da667069","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"e4347211-7266-42a5-9f94-157e05b5c998"},{"__attrId":"192"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((previous_transaction_status#233 IN (Paid,Validated) AND transaction_status#178 IN (Paid,Validated)),first_valid_status_date#192)"]}},{"id":"4c44be70-425b-48e6-b63e-9c035feec261","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__exprId":"6be35c7c-083d-4cd5-a5ba-a6f4c4d8ad7b"},{"__attrId":"82"},{"__exprId":"bd881d93-e905-4d89-ab9c-cc68da667069"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["(((NOT previous_transaction_status#233 IN (Paid,Validated) OR isnull(previous_transaction_status#233)) AND transaction_status#178 IN (Paid,Validated)),created#82)"],"elseValue":"CASE WHEN (previous_transaction_status#233 IN (Paid,Validated) AND transaction_status#178 IN (Paid,Validated)) THEN first_valid_status_date#192 END"}},{"id":"5f0ec7d0-9d30-4e29-870b-74c962a3beda","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"4c44be70-425b-48e6-b63e-9c035feec261"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"b817a1b9-3376-4f2c-a81b-16c86913ee66","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"5f0ec7d0-9d30-4e29-870b-74c962a3beda"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"bi_validated_date","params":{"name":"bi_validated_date","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(240,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"1f209779-08ad-409c-8529-a6c4baaec36f","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"RowNumber","_typeHint":"expr.Generic"},"name":"row_number"},{"id":"55c59fa5-c7b9-4e71-a793-98e157378d00","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"82"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Descending","nullOrdering":"NullsLast"}},{"id":"a722f426-c33a-4ed0-a725-02361e3c36fa","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"UnboundedPreceding$","_typeHint":"expr.Generic"},"name":"unboundedpreceding$"},{"id":"4233f50b-d141-453c-ae8c-7751cc69f258","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"CurrentRow$","_typeHint":"expr.Generic"},"name":"currentrow$"},{"id":"820e061c-30fe-4137-98fa-4a0d73e6d988","childRefs":[{"__exprId":"a722f426-c33a-4ed0-a725-02361e3c36fa"},{"__exprId":"4233f50b-d141-453c-ae8c-7751cc69f258"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"d23a34db-179b-4ccc-81ec-fed813eadc09","childRefs":[{"__attrId":"87"},{"__exprId":"55c59fa5-c7b9-4e71-a793-98e157378d00"},{"__exprId":"820e061c-30fe-4137-98fa-4a0d73e6d988"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#87"],"orderSpec":["created#82 DESC NULLS LAST"]}},{"id":"6dac0a74-c434-462c-9e04-2a4ddecc5b17","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"1f209779-08ad-409c-8529-a6c4baaec36f"},{"__exprId":"d23a34db-179b-4ccc-81ec-fed813eadc09"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"2aad6e3a-c25b-4fb4-b323-f766428a32a4","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"6dac0a74-c434-462c-9e04-2a4ddecc5b17"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"row_number","params":{"name":"row_number","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(737,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"ce27fdda-5ea3-4430-8fa6-bc563e46f6c6","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"RowNumber","_typeHint":"expr.Generic"},"name":"row_number"},{"id":"368a0ef1-23bc-48cf-967a-84db602b39b8","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"82"}],"extra":{"simpleClassName":"SortOrder","_typeHint":"expr.Generic"},"name":"sortorder","params":{"direction":"Descending","nullOrdering":"NullsLast"}},{"id":"0484408b-25e6-4c2b-9870-03d305794764","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"UnboundedPreceding$","_typeHint":"expr.Generic"},"name":"unboundedpreceding$"},{"id":"219f8cc0-bccd-4484-aad5-03f9be16615e","dataType":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","extra":{"simpleClassName":"CurrentRow$","_typeHint":"expr.Generic"},"name":"currentrow$"},{"id":"4fe7c81e-f544-4b48-a036-c13a44abbc7c","childRefs":[{"__exprId":"0484408b-25e6-4c2b-9870-03d305794764"},{"__exprId":"219f8cc0-bccd-4484-aad5-03f9be16615e"}],"extra":{"simpleClassName":"SpecifiedWindowFrame","_typeHint":"expr.UntypedExpression"},"name":"specifiedwindowframe","params":{"frameType":"RowFrame"}},{"id":"6f19dfde-eb97-4bba-9287-a23fdcf1b31c","childRefs":[{"__attrId":"87"},{"__exprId":"368a0ef1-23bc-48cf-967a-84db602b39b8"},{"__exprId":"4fe7c81e-f544-4b48-a036-c13a44abbc7c"}],"extra":{"simpleClassName":"WindowSpecDefinition","_typeHint":"expr.UntypedExpression"},"name":"windowspecdefinition","params":{"partitionSpec":["unique_id#87"],"orderSpec":["created#82 DESC NULLS LAST"]}},{"id":"0f773cab-d6ea-46e7-bbf8-d39b175e7bf4","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"ce27fdda-5ea3-4430-8fa6-bc563e46f6c6"},{"__exprId":"6f19dfde-eb97-4bba-9287-a23fdcf1b31c"}],"extra":{"simpleClassName":"WindowExpression","_typeHint":"expr.Generic"},"name":"windowexpression"},{"id":"f7bdfab8-3323-409a-9bf7-33c9e7e4eae1","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__exprId":"0f773cab-d6ea-46e7-bbf8-d39b175e7bf4"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"row_number","params":{"name":"row_number","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(249,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a6125d71-c195-421a-827d-066021062409","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"737"},{"__exprId":"7ebc0637-fe41-48d6-9048-95c3996174f5"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"367544a9-f532-4c72-a172-dd79f8d56491","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"249"},{"__exprId":"2598f13d-9085-4a78-b7c0-762877a4f89e"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"44536478-ffc3-4da5-84f4-97cc706daa79","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"27"},{"__attrId":"87"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"1b358996-265a-4375-af2f-43ccdcff40e0","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__attrId":"27"},{"__attrId":"87"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"0b0dd853-5225-4a5e-b771-06cc062d15d4","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"716"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"208d97c5-5907-47af-80e2-8f1d3af709e9","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"394"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"fd5ffd93-7135-4bcb-9138-db270e42fdab","dataType":"8db3d235-3641-4d3e-91b8-263b9d02bf6e","childRefs":[{"__exprId":"b40997e8-d2da-4a39-96e1-2f424ebb638a"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"7f9def2d-8882-4a62-9f58-46880f0c6453","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"fd5ffd93-7135-4bcb-9138-db270e42fdab"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"81eb0915-d658-4447-82eb-a5618f7e63eb","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"208d97c5-5907-47af-80e2-8f1d3af709e9"},{"__exprId":"7f9def2d-8882-4a62-9f58-46880f0c6453"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"b581b8f9-6b00-4c9b-9e8b-f0de6a0c69c0","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"0b0dd853-5225-4a5e-b771-06cc062d15d4"},{"__exprId":"81eb0915-d658-4447-82eb-a5618f7e63eb"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"baa8da20-4cb9-4a1f-a31b-932b989fa34b","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"b581b8f9-6b00-4c9b-9e8b-f0de6a0c69c0"},{"__attrId":"716"},{"__attrId":"394"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((isnotnull(previous_commission#716) AND (cast(commission#394 as decimal(19,3)) = cast(cast(0 as decimal(1,0)) as decimal(19,3)))),previous_commission#716)"],"elseValue":"commission#394"}},{"id":"71256fc7-359c-4429-af54-896465c630cb","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"baa8da20-4cb9-4a1f-a31b-932b989fa34b"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(776,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"6b7c7378-bb4f-4c8c-b656-d9c6f0551ecd","dataType":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","childRefs":[{"__attrId":"726"}],"extra":{"simpleClassName":"IsNotNull","_typeHint":"expr.Generic"},"name":"isnotnull"},{"id":"9368ad16-e3ae-4d8f-93ce-cd7d61f3182a","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"463"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"312f8b34-2295-431e-b927-382351fadf7c","dataType":"8db3d235-3641-4d3e-91b8-263b9d02bf6e","childRefs":[{"__exprId":"0681599c-66c8-47c5-a881-e7c0c5713ce1"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"84f885a6-c1e7-405c-9140-e8b24c96f33f","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"312f8b34-2295-431e-b927-382351fadf7c"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"faa604c2-d386-474f-ac92-d087e3b8b8dd","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"9368ad16-e3ae-4d8f-93ce-cd7d61f3182a"},{"__exprId":"84f885a6-c1e7-405c-9140-e8b24c96f33f"}],"extra":{"simpleClassName":"EqualTo","_typeHint":"expr.Binary","symbol":"="},"name":"equalto"},{"id":"327c0169-1ce9-4ac6-8415-c24133a1b03b","dataType":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","childRefs":[{"__exprId":"6b7c7378-bb4f-4c8c-b656-d9c6f0551ecd"},{"__exprId":"faa604c2-d386-474f-ac92-d087e3b8b8dd"}],"extra":{"simpleClassName":"And","_typeHint":"expr.Binary","symbol":"&&"},"name":"and"},{"id":"a30f6571-87f4-48d7-a62a-3eb8c85fd957","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"327c0169-1ce9-4ac6-8415-c24133a1b03b"},{"__attrId":"726"},{"__attrId":"463"}],"extra":{"simpleClassName":"CaseWhen","_typeHint":"expr.Generic"},"name":"casewhen","params":{"branches":["((isnotnull(previous_total#726) AND (cast(total#463 as decimal(19,3)) = cast(cast(0 as decimal(1,0)) as decimal(19,3)))),previous_total#726)"],"elseValue":"total#463"}},{"id":"c649fcc4-565b-45d3-abd0-0d955f9552bc","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__exprId":"a30f6571-87f4-48d7-a62a-3eb8c85fd957"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total","params":{"name":"total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(799,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"1e67f76c-df9a-4b22-a6d0-a07913e2d961","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"27"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"unique_id","params":{"name":"unique_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(863,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"5d5077f4-a04f-4b3f-866d-3c2c984f8d9d","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"21"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"country_iso","params":{"name":"country_iso","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(884,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"724cfbe5-e797-409e-9858-4b716b274e80","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"328"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"clickout_id","params":{"name":"clickout_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(905,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"ab789527-973c-43fa-bcb8-308bb3d441d2","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__attrId":"264"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"affiliate_network","params":{"name":"affiliate_network","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(926,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"2264a5ea-bf12-4c9f-99db-1584968c29af","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"799"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total","params":{"name":"total","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(947,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"073852da-b3d7-447c-924a-5aad2a5e18b7","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"361"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"program_id","params":{"name":"program_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(968,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"b955d63c-2bb5-4336-86ac-2beac87316f8","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"23"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"currency","params":{"name":"currency","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(989,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"4b911110-309f-4394-b044-40e47cbd1cd2","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"776"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission","params":{"name":"commission","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1010,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"5194b68b-7a0b-42a3-84a4-45d42fa1433e","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"296"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"time_of_event","params":{"name":"time_of_event","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1031,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"59de4722-7560-4148-bc5d-f399f0a2aa56","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"499"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_type","params":{"name":"transaction_type","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1052,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"15c4623b-43a0-4582-9a4f-e042d8c0c132","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"428"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_status","params":{"name":"transaction_status","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1073,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"e1a3b3cd-eca6-44dc-b0f0-5e0479e0e23d","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"26"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_id","params":{"name":"transaction_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1094,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"9c386400-1883-47cb-b742-5f2ce22dfe6f","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"25"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"affiliate_network_id","params":{"name":"affiliate_network_id","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1115,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"4616a7c3-a90e-493e-8d63-2924821b0f22","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","childRefs":[{"__attrId":"18"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"transaction_source","params":{"name":"transaction_source","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1136,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"a7e75a99-cc7a-4ae2-9fac-919c7b52582a","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"22"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"created","params":{"name":"created","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1157,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"7f4e059b-b887-4518-a94a-9347d5f7d4f6","dataType":"8163a011-64f4-46c3-9228-ec80bf5817ed","childRefs":[{"__attrId":"28"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"updated","params":{"name":"updated","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1178,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"35813355-3089-4674-9d6c-a1598f2e6939","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","childRefs":[{"__attrId":"536"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"vp_flag","params":{"name":"vp_flag","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1199,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"fd92a1fd-de36-42de-90ff-9172ac392fd5","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"151"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"total_original","params":{"name":"total_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1220,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"e20f05cf-52a9-4927-a006-c8bedad935f4","dataType":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","childRefs":[{"__attrId":"156"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"commission_original","params":{"name":"commission_original","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1241,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"9be27bc3-4754-4cbb-89e8-e8b0d4618844","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__attrId":"240"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"bi_validated_date","params":{"name":"bi_validated_date","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1262,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"cb523fd2-c05c-4c8d-94fb-b9f50a166a15","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","childRefs":[{"__attrId":"926"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"affiliate_network","params":{"name":"affiliate_network","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1283,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}},{"id":"b3c220de-6366-4e41-bad4-e017947cea35","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__attrId":"1262"}],"extra":{"simpleClassName":"Cast","_typeHint":"expr.Generic"},"name":"cast","params":{"timeZoneId":"UTC"}},{"id":"3814f401-080c-43cf-97b2-06e1c6fe51d0","dataType":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","childRefs":[{"__exprId":"b3c220de-6366-4e41-bad4-e017947cea35"}],"extra":{"simpleClassName":"Alias","_typeHint":"expr.Alias"},"name":"bi_validated_date","params":{"name":"bi_validated_date","nonInheritableMetadataKeys":["__dataset_id","__col_position"],"explicitMetadata":"{}","exprId":"ExprId(1304,c9ea7f77-eece-4d4d-aba9-636a2b685e7e)"}}],"constants":[{"id":"b0a78985-943a-4037-8881-cda41d728a7b","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"adcell"},{"id":"d0cfc096-b281-435c-bb62-5998a90b0004","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0},{"id":"85aa44fc-2250-4051-9cdd-5171d9089804","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":42},{"id":"2e933b29-cdf0-4e88-8693-56386810a939","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"accepted"},{"id":"4db7d5f7-f2d5-4d33-887f-c9a215cb8009","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"36db5e5a-ccd5-4820-89b2-1088c6e1e62a","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"open"},{"id":"29b8329b-73c2-4c7e-809b-c26396f7a8dd","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Pending"},{"id":"4d52f8e7-3a6d-4e1f-b80c-35a3b54a6952","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cancelled"},{"id":"794349e4-8a93-4ecd-86d4-b34fe9361be7","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"2d936cc4-7275-4d37-8a2b-0f1c1d1eaacd","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"818e4a68-6a2e-4925-9f8d-6d8c9701dc41","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"accepted"},{"id":"93535947-8e6b-45d3-8b98-cafb40553730","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"85b36c0d-a4e1-4325-9a58-fa047a6dfba3","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"open"},{"id":"651e2c14-aaca-432a-b531-a22886cea8d1","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Pending"},{"id":"67b6accb-c8f1-4dcb-b80c-ebe2699cb954","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cancelled"},{"id":"5022e25e-0f3c-453b-9beb-ff2af5b9e993","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"9b278aec-00c1-4c2d-a6ec-0a8fd525c366","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"c59f73ac-8b4e-44fb-9f22-189e30cd889b","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":" \t\n\r"},{"id":"bedc75d2-c192-4820-b5eb-a5ac5adb04a7","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":""},{"id":"2452b137-5bdd-4a88-95ff-330d4af2ae7c","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"80cc3b18-b214-46cd-8e95-6fbcfa2cad0c","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"accepted"},{"id":"b156da56-2c67-4046-a08e-0b30d04803c2","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"3da37baa-8c6a-4f3a-afbf-ddfad82057c3","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"open"},{"id":"c356439e-1df0-4718-9756-5b7503130697","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Pending"},{"id":"7d2523a1-8944-469a-b299-f5bee631bb85","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cancelled"},{"id":"14a5a040-5e0d-4150-99ac-a6fe0e087c74","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"be1109d0-e6c1-4646-8a8d-9a86bc3cae29","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"2972cb2e-d2ec-4548-a777-a066a56ae0d4","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"accepted"},{"id":"c566e6c8-fd0a-4121-8c15-3356815bdf91","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"f4a6d03d-ae3d-4311-86b5-9f7f96157f75","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"open"},{"id":"6c0ff076-3107-4615-9ba3-2d222035a5d5","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Pending"},{"id":"3744b8a3-7aee-4f54-a329-bd703fd645f3","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cancelled"},{"id":"1ffdd9d8-083a-4386-b509-0be134ccf7b3","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"8aa1aa07-a42d-4502-b4e4-935b0a59b16a","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"5989c344-750c-4167-9c54-835d6aab5e95","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":" \t\n\r"},{"id":"fecfe53e-96a4-4ada-bdea-335ed59392d2","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":""},{"id":"69cd10dc-3f1b-401b-8243-7f38eacb4cb1","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Paid"},{"id":"53b22c18-c0bf-4b62-b970-682e4250e042","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"0b35c07c-1c09-48c3-83b0-f9aa558a60ae","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"accepted"},{"id":"c571faee-cb84-4ca3-91fe-968d62a6b9d0","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"40e36e2a-c23c-404b-a15d-817e5675b6d2","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"open"},{"id":"91641846-d21e-4e7a-8a67-bdd157b5ad67","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Pending"},{"id":"870ba440-65b7-4244-861d-7cb8c15d99fb","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cancelled"},{"id":"850e3681-759a-4d5b-8ea6-c099c9c345a4","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"7c25e41d-23cb-44a8-adc0-17d0edfa88f0","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"724a267f-1209-4668-b29c-897a53676a4d","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"6a42fc85-54aa-48f7-8113-2879ac58171d","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Refused"},{"id":"20f48cae-bee5-4cfa-b281-c07b5b249cbb","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"sale"},{"id":"67e0885e-e4fd-4d57-9ff7-c377c91703ab","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Sale"},{"id":"d4718826-bc7b-4bba-86a5-292b80631422","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"lead"},{"id":"c8f2fe4f-9a78-43a6-99a6-8d4a8967d4c7","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Lead"},{"id":"3f1ac1f0-1932-4319-8e73-2c472cacd0b3","dataType":"427a2363-d849-445a-9e57-96a389fcb04a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"2593968a-9c06-4463-8199-9c511a3fa6f0","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":42},{"id":"21b44c2a-0b84-4b90-a4a8-160c5d89763e","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"f97722da-3ed9-44f9-a49a-ac4b37ceb097","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":2},{"id":"4c052b2d-2563-4fd3-ae5c-28a6a4570c72","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cn"},{"id":"976f442c-2da8-400b-b499-b6c860418b4e","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"wl"},{"id":"65acbda2-9d6f-4a06-9b7b-401cec00b8ba","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"dl"},{"id":"771bb9ad-8f41-4fa2-b2da-29f32c1741fc","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"ps"},{"id":"280b2f61-f3c2-4661-ba6a-3fd3ddd6886a","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"sp"},{"id":"8981fd54-0d7a-4db2-ab75-37c1da25afa6","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"la"},{"id":"8edd88d5-cb30-45cc-8c2a-536f0f1d4911","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"cd"},{"id":"7da6d60b-f079-4a40-868e-c7d1baf1a2ee","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0},{"id":"0d69c446-cdd6-438a-a94b-55ccbdebf049","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"extras"},{"id":"8c0b558d-5693-4c18-9c7d-e6dc0156cb92","dataType":"ce1911cd-0b78-4460-a31d-2079708b4d0b","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"306b7292-e648-4719-8018-6dd9de4ef3b5","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"cb45f640-e35e-4977-9025-643f53e4612f","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"b89fb3d4-7447-48a5-9b12-86ef999bd98c","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"8d15dd62-95d8-47a2-baa9-38376ea01c5a","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"b63ca2b3-25b9-4a67-93fd-07f8d5d95103","dataType":"e50a90ab-433f-4f32-8d48-77055dfb9637","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":null},{"id":"7aea1ea3-2fe0-47c6-827e-efb77e42c94f","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":-1},{"id":"d8a40522-6fbf-49fc-b7a6-34333dbe1555","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0},{"id":"f8e5d6e1-72f8-4650-9a7e-2713d76618f6","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0},{"id":"10aae182-d836-4ad4-adfe-a36e2e6e6713","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Paid"},{"id":"b3a5f1d9-fd93-4cee-b99b-951f55ab910f","dataType":"d952ae5c-a2ab-4422-8ee6-b635daca232a","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":"Validated"},{"id":"7ebc0637-fe41-48d6-9048-95c3996174f5","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"2598f13d-9085-4a78-b7c0-762877a4f89e","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":1},{"id":"b40997e8-d2da-4a39-96e1-2f424ebb638a","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0},{"id":"0681599c-66c8-47c5-a881-e7c0c5713ce1","dataType":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","extra":{"simpleClassName":"Literal","_typeHint":"expr.Literal"},"value":0}]},"systemInfo":{"name":"spark","version":"3.1.2"},"agentInfo":{"name":"spline","version":"0.6.1"},"extraInfo":{"appName":"CustomerTransactionAdcellCn","dataTypes":[{"_typeHint":"dt.Simple","id":"427a2363-d849-445a-9e57-96a389fcb04a","name":"string","nullable":true},{"_typeHint":"dt.Simple","id":"8163a011-64f4-46c3-9228-ec80bf5817ed","name":"timestamp","nullable":true},{"_typeHint":"dt.Simple","id":"50a65485-99b1-4d6c-92e0-f55dc9a3ea08","name":"decimal(19,3)","nullable":true},{"_typeHint":"dt.Simple","id":"ce1911cd-0b78-4460-a31d-2079708b4d0b","name":"integer","nullable":true},{"_typeHint":"dt.Simple","id":"208d3fff-b45a-4f21-a64a-04c2b75d1f11","name":"long","nullable":true},{"_typeHint":"dt.Simple","id":"d952ae5c-a2ab-4422-8ee6-b635daca232a","name":"string","nullable":false},{"_typeHint":"dt.Simple","id":"8563cc72-9dc5-4359-a961-9c9bedccbbb1","name":"integer","nullable":false},{"_typeHint":"dt.Simple","id":"8c0a7ab7-c4f8-401e-af46-31acaeac21be","name":"boolean","nullable":true},{"_typeHint":"dt.Simple","id":"469a4c99-b4ea-44e2-aa1c-24d289860d5d","name":"boolean","nullable":false},{"_typeHint":"dt.Simple","id":"9240cf75-2ae8-4bf3-979d-c2dd7989e2a2","name":"null","nullable":false},{"_typeHint":"dt.Simple","id":"e50a90ab-433f-4f32-8d48-77055dfb9637","name":"null","nullable":true},{"_typeHint":"dt.Simple","id":"8db3d235-3641-4d3e-91b8-263b9d02bf6e","name":"decimal(1,0)","nullable":true},{"_typeHint":"dt.Simple","id":"ee6909e9-e229-4bd9-8e18-b09dd44a67f3","name":"date","nullable":true}]}}]

I hope this helps

@kuhnen
Copy link

kuhnen commented Jul 5, 2021 •
edited by wajda
Loading

One more small update, when trying to use kafka as the gateway I got this:

19:25:28.005 [org.springframework.kafka.KafkaListenerEndpointContainer#0-0-C-1] ERROR z.c.a.s.g.k.l.ExecutionsListener - Error while inserting execution event for planId:b0f872f8-2ad6-49b5-8fad-543b4710a067 and timestamp: 1625513119848 from topic:spline-topic on offset:7
za.co.absa.spline.producer.service.InconsistentEntityException: Inconsistent entity: Unresolved execution plan IDs: b0f872f8-2ad6-49b5-8fad-543b4710a067
	at za.co.absa.spline.producer.service.repo.ExecutionProducerRepositoryImpl$.za$co$absa$spline$producer$service$repo$ExecutionProducerRepositoryImpl$$createInsertTransaction(ExecutionProducerRepositoryImpl.scala:168)

@wajda
Copy link
Contributor

wajda commented Jul 19, 2021

Regarding the Unresolved execution plan IDs, I think it's because the previous error - the execution plan processing failed, and hence, so did the subsequent execution event referencing it.

@wajda wajda added this to the 0.6.1 milestone Jul 19, 2021
@kuhnen
Copy link

kuhnen commented Jul 19, 2021

@wajda thanks :). Would be great if you could give me a hint on which components we would need to change to fix this 👍 .
I am open to trying a pull request in the name of the company that I work. We already have a few pull requests for the tool GREAT_EXPECTATIONS and would be awesome to be able to contribute to one more tool.

@wajda
Copy link
Contributor

wajda commented Jul 19, 2021

Sure, let me take a look at it first. I've got some stuff to catch up on after my holiday, so give me a day or two :)

@kuhnen
Copy link

kuhnen commented Jul 28, 2021

@wajda :). any news here :). Just a friendly reminder 👍

@wajda
Copy link
Contributor

wajda commented Jul 28, 2021

no worries, I'll get to it this week.

@wajda wajda self-assigned this Jul 28, 2021
@wajda
Copy link
Contributor

wajda commented Jul 29, 2021

I reproduced the error. Working on it.

@wajda
Copy link
Contributor

wajda commented Jul 29, 2021

It seems like it's an agent issue - the JSON contains attributes with duplicated IDs (e.g. 123)
What agent version are you using?

@kuhnen
Copy link

kuhnen commented Jul 29, 2021

@wajda I used the most recent I could, on the day I wrote this. I am pretty sure it was 0.6.1

@wajda wajda mentioned this issue Jul 29, 2021
Closed
@wajda
Copy link
Contributor

wajda commented Jul 29, 2021

Thanks Andre. I filed a ticket in the agent repo. I'll also add some validation on the server side, to make the error messages clearer.

@kuhnen
Copy link

kuhnen commented Jul 29, 2021

@wajda thanks a lot 👍

wajda added a commit that referenced this issue Jul 29, 2021
@wajda
spline #925 add unique constraint validation on ExecutionPlan operati…
2670956 
…on IDs, attribute IDs and expression IDs
wajda added a commit that referenced this issue Jul 29, 2021
@wajda
spline #925 minor: add missing private modifier
1bf3b59
wajda added a commit that referenced this issue Jul 30, 2021
@wajda
spline #925 add unique constraint validation (#930)
e912e79 
* spline #925 add unique constraint validation on ExecutionPlan operation IDs, attribute IDs and expression IDs

* spline #925 minor: add missing `private` modifier
@wajda wajda closed this as completed Jul 30, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wajda wajda

Labels
bug component: Producer
Projects
Spline
Status: Done
Milestone
0.6.1
Development

No branches or pull requests
4 participants
@wajda @kuhnen @cerveada @rsaw4