Oct 21 2019 11:34 AM
Can I access some logs on why my Kusto query failed? I am unable to troubleshoot the failure
I need to investigate why the query fails, so that I can optimize my query
Below is the log of the failure
{"ExecutionTime":108.5802688,"resource_usage":{"cache":{"memory":{"hits":15621348,"misses":2222,"total":15623570},"disk":{"hits":573,"misses":52,"total":625},"shards":{"hitbytes":0,"missbytes":0,"bypassbytes":0}},"cpu":{"user":"00:22:37.3437500","kernel":"00:01:57.7500000","total cpu":"00:24:35.0937500"},"memory":{"peak_per_node":43625738960}},"input_dataset_statistics":{"extents":{"total":2663407,"scanned":5629,"scanned_min_datetime":"2019-10-21T15:39:34.7253024Z","scanned_max_datetime":"2019-10-21T18:05:23.3584546Z"},"rows":{"total":3115175613826,"scanned":2138581223},"rowstores":{"scanned_rows":0,"scanned_values_size":0}},"dataset_statistics":[{"table_row_count":4,"table_size":555}]}
Oct 23 2019 05:31 AM - edited Oct 23 2019 05:33 AM
you can see the FailureReason by running ".show queries" and filtering to the ClientActitivityId which is relevant to the execution you're looking into.
if you need assistance with optimizing the query after going through query best practices and making sure all of them have been implemented in your query, please share the query.
https://docs.microsoft.com/en-us/azure/kusto/query/best-practices