Hello, I am new to this forum and Azure Data Explorer and am looking for some advice.
I have a table with approx 1.2 Billion records and growing
I'm attempting to perform a select distinct field1,field2 from table1
After approx 4 minutes, the query times out with Client Request NetworkError.
I believe I have hit the Limit Execution Timeout which defaults to 4 minutes.
So I'm looking for advice on alternative (more efficient) ways of achieving this query
Any advice would be greatly appreciated!