zzcclp edited a comment on issue #3357: [CARBONDATA-3491] Return updated/deleted rows count when execute update/delete sql URL: https://github.com/apache/carbondata/pull/3357#issuecomment-520730493 I tried but it didn't work too. @kevinjmh The explain result is: ``` == Parsed Logical Plan == UpdateTable 'UnresolvedRelation `test_return_row_count`, [b], select 'ddd' from test_return_row_count, test_return_row_count, where a = 'ccc' == Analyzed Logical Plan == ProjectForUpdate 'UnresolvedRelation `test_return_row_count`, [b] +- Project [a#11, b#12, c#13, tupleId#209, b-updatedColumn#210] +- Filter (a#11 = ccc) +- SubqueryAlias test_return_row_count +- SubqueryAlias test_return_row_count +- Project [a#11, b#12, c#13, tupleId#209, ddd AS b-updatedColumn#210] +- SubqueryAlias test_return_row_count +- Project [a#11, b#12, c#13, UDF:getTupleId() AS tupleId#209] +- SubqueryAlias test_return_row_count +- SubqueryAlias test_return_row_count +- Relation[a#11,b#12,c#13] CarbonDatasourceHadoopRelation == Optimized Logical Plan == CarbonProjectForUpdateCommand Project [a#11, c#13, UDF:getTupleId() AS tupleId#209, ddd AS b-updatedColumn#210], test_return_row_count, [b] == Physical Plan == Execute CarbonProjectForUpdateCommand +- CarbonProjectForUpdateCommand Project [a#11, c#13, UDF:getTupleId() AS tupleId#209, ddd AS b-updatedColumn#210], test_return_row_count, [b] ``` And the executedPlan schema is: ``` root |-- Updated Row Count: long (nullable = false) ``` As shown above, it seems right, but it can't return right result.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
