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.
- Where is Update Policy failure logged
- 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
- KQL Query for Calculation of ErrorDuration within Timespan
- Add text to point(s) in Kusto linechart
- Kusto query with multiple sample values from an aggregate
- How to get data for specific date (startofweek) in a given time range in KQL?
- Defining external table kind as delta
- Kusto query map through array
- java.io.UncheckedIOException: io.netty.channel.StacklessClosedChannelException while writing to adx
- KQL: Every time a word is mentioned in a column append it to a new column as a list
- KQL: Create an id column every time a value changes in column x ordered by another column y
- Display lines & values for whole range of y-axis values in Kusto linechart
- Kusto - fetch data from one table where matching records do not exist in another table
- KQL - extract property value from an array of JSON objects, based on the value of another property
- KustoIngestFactory fails to load dependent assembly at runtime with FileNotFoundException
- KQL: How to reference columns within a let query in the next query
- Create a function to calculate power of tens with a loop and reuse them in another query
- Generate Chart by Type and State
- Azure Data Explorer C# querying and ORM
- Is it possible to update rows in Azure Data Explorer (Kusto)
- Kusto query for time between records by group in one result list
- Build a tree / run recursive query in Kusto Azure Data Explorer
- Where do Kusto dashboard definitions live
- Adding fixed delay to Update Policy execution
- insert an array in column of the kql table
- Stuck at PIM Diagnostics via KQL
- Grouping on the basis of cumulative sum
- How to use table alias in KQL query