Microsoft Azure Kusto Java client library which allows communication with Kusto to bring data in (ingest) and query information already stored in the database.
Questions tagged [kusto-java-sdk]
13 questions
3
votes
2 answers
Dynamically return columns from a kusto function
I have a set of telemetry data stored in a table in the below format. Lets call this table as RawTelemetryData
device_id
TIME
ABC
DEF
GHI
LMN
123
2021-04-20 00:00:00.0000000
1
2
3
4
121
2021-04-20 00:00:00.0000000
1
2
3
4
The above…
Justin Mathew
- 950
- 8
- 34
2
votes
1 answer
PySpark Kusto Connector on Azure Databricks
I am using Azure databricks with LTS 7.3 and spark 3.0 (PySpark) with com.microsoft.azure.kusto:kusto-spark_3.0_2.12:2.9.1 connector for quite sometime now but recently my jobs are failing with below errors (randomly, sometimes they run and…
Bha123
- 53
- 5
2
votes
2 answers
How to unpivot columns in kusto/kql/azure and put multiple columns into one
I got a table like this in Azure analytics with Kusto for the game I'm working on
datatable (ID_player:string, Timestamp:timespan, monster1:int, monster2:int, monster3:int)
[
"aaa", "12:00:00", 1,2,3
,"aaa", "12:10:00", 4,7,0
,"bbb",…
ianux22
- 405
- 4
- 16
2
votes
1 answer
ADX Pagination for query result
I have a function which returns huge number of rows. I need to paginate this data so that I can efficiently render on the UI. I tried to implement using Stored query results. But unfortunately its in preview mode as per the below link, and shouldn't…
Justin Mathew
- 950
- 8
- 34
2
votes
1 answer
How to summarize time window based on a status in Kusto
I have recently started working with Kusto. I am stuck with a use case where i need to confirm the approach i am taking is right.
I have data in the following format
In the above example, if the status is 1 and if the time frame is equal to 15…
Justin Mathew
- 950
- 8
- 34
1
vote
1 answer
Use of Percentile with condition in Kusto
I'm looking to use percentile() in kusto with certain condition
here's the data I have,
OnStatus| OffStatus | WebId | UserId |
true | false | 1 | A123 |
true | false | 2 | A123 |
true | false | 3 | A123 …
Swasti
- 187
- 1
- 5
- 20
0
votes
2 answers
Equivalent Data Type in Java for Datetime in Kusto
I am using Datetime in Kusto. What should be the data type in Java to ingest to Kusto as datetime?
Example: I am setting StartTime:datetime, EndTime: datetime as column type. I have tried Date as type in java but Kusto is not accepting this…
superninja
- 3,114
- 7
- 30
- 63
0
votes
2 answers
Unable to authenticate Kusto Client using JWTToken
We use Java 8 and msal4j version 0.6.0-preview. To connect to Kusto, we use JWT Token:
ConnectionStringBuilder csb = ConnectionStringBuilder.createWithAadAccessTokenAuthentication(resourceUri, accessToken);
Client kustoClient =…
superninja
- 3,114
- 7
- 30
- 63
0
votes
1 answer
No such method for createFromSecret()
I am using msal4j library on version 0.6.0-preview and java 8 in the repo.
com.microsoft.azure
msal4j
…
superninja
- 3,114
- 7
- 30
- 63
0
votes
2 answers
Problem in Kusto Query Language with length of text
I'm working in Kusto Query Language and I would like to display not everything from the selected string.
My string is 'Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 50000. Error…
AndreasB
- 11
- 1
0
votes
1 answer
Measuring the success rate of a command executed using Kusto Query
I am trying to find the success rate of a command (e.g call). I have scenario markers in place that marks the success, and the data is collected. Now I am using the Kusto queries to create a dashboard that measures the success rate when the command…
Angus
- 12,133
- 29
- 96
- 151
0
votes
1 answer
How to get value of a cell by column name in java using azure-kusto-java library
public KustoResultSetTable executeKustoQuery(ClientImpl client, String query) {
KustoResultSetTable mainTableResult = null;
try {
KustoOperationResult results = client.execute(databaseName, query);
mainTableResult =…
GurdeepBhatia
- 23
- 6
0
votes
1 answer
Azure Kusto Java SDK get all columns of query results
I'm using the Azure Kusto Java SDK v2.0.1 with Scala over Java8.
I'm executing some query:
val query = " ... "
val tenantId = " ... "
val queryResponse = client.execute(tenantId, query)
val queryResponseResults = queryResponse.getPrimaryResults
I…
sheldonzy
- 5,505
- 9
- 48
- 86