azure-data-explorer
How to clear ingress queue?
I sent 1000 invalid items for ingestion through LightIngest.exe. Each individual item takes around 10 minutes before it fails due to connectivity problems:
I am not able to proceed with valid items as they are added to the tail of the queue. How can I reset the queue?
Solution
There is no way today to reset or clear the queue. You have the following options:
- Wait - the retries are exponential, so the impact of the rouge items will be diminished significantly as more time passes
- Rename the table - the ingestions in the queue will fail and the queue will be cleared up. Please note however that when you rename the table back to the original name, items that are still waiting in the queue for a "retry" will continue to fail when their time arrives (since the table is back into its original name). So the closer that you do it to the actual error the better.
- Is there a query to run so I can get a list of users who has NOT logged in, in the past 30 days?
- Compare multiple column value and return column name with max value
- trying to find out week of year in kql
- Azure Data Explorer - plot graph per user over time
- Turning off Kusto database cache policy not reflecting in reduced cache as shown by .show cache command
- Kusto command for generating create table & function script
- How to make right table data for pie chart rendering?
- Get percent value from total sum row in pivot mode
- Azure Data Explorer dashboard automation
- How to ingest inline into Azure Data Explorer Table from PowerShell?
- EventHubValidationErrorFound mapping does not exist
- KQL query to extend new column with other row values
- What is considered an ingestion request in Azure Data Explorer?
- Kql function to append columns
- Kibana Query for Message that contains ":"
- Get Azure VM creation date
- How good is performance of "has" operator in Kusto when RHS is not exactly one term?
- Stuck at PIM Diagnostics via KQL
- union with all fields
- How to create an Alert for Data Collection Rule deletion across all VMs in a subscription?
- Are joins within the same cluster consistent and isolated in Azure Data Explore?
- Is it possible to change the day returned from startofweek() and endofweek()?
- How to run Get Kusto query using Rest API
- KQL: bag unpack json into single row
- ADX - KQL: Conditionally Extending Property Columns from Dynamic Column
- Where is Update Policy failure logged
- Need suggestion to implement restrictive permissions to Kusto Tables and Functions
- How to do a KQL time window join at millisecond granularity?
- Kusto Query replace the timestamp of duplicate rows
- Using Kusto scan operator to capture sequential pairs that meets criteria