Questions tagged [adx]

ADX is the name of Intel's arbitrary-precision arithmetic instruction set for the x86 architecture. Questions about azure data explorer should NOT use this tag; the [azure-data-explorer] tag should be used instead.

Intel ADX (Multi-Precision Add-Carry Instruction Extensions) is Intel's arbitrary-precision arithmetic extension to the x86 instruction set architecture (ISA). Intel ADX was first supported in the Broadwell micro-architecture

The instruction set extension contains just two new instructions, though MULX from BMI2 is also considered as a part of the large integer arithmetic support

Both instructions are more efficient variants of the existing ADC instruction, with the difference that each of the two new instructions affects only one flag, where ADC as a signed addition may set both overflow and carry flags, and as an old-style x86 instruction also reset the rest of the CPU flags. Having two versions affecting different flags means that two chains of additions with carry can be calculated in parallel.

Source: Wikipedia (Intel ADX)

83 questions
0
votes
0 answers

Strategy which opens trade if (1) SMA20 upwards (2) ADX 30+ (3)falling under SMA20

This script should open a trade under the following conditions SMA20 goes up Last closing falls under SMA20 ADX is above 30 it shall use the highest high of the last 5 candels as take profit and the lowest low of the last 5 candles as stop…
0
votes
1 answer

ADX Table specify UTC time in policy retention period

Is it possible to specify a UTC time when deleting data in a table in Azure Data Explorer? For example: My Table is constantly being ingested with an Event Hub. I want my Table retention policy to only keep data from 00:15:00 UTC to 00:15:00 UTC of…
Alejandro Alvarez
  • 131
  • 1
  • 3
  • 9
0
votes
1 answer

ADX: Update policy cross database

Is it possible to create an update policy across databases? I mean like table_1 in db_1 should send data via update policy to table_2 in db_2. If not, why does it not work? And: What about functions? Can i select data across dbs?
0
votes
1 answer

I want to refer a parameter inside a parameter in power BI

I have 3 adx tables named country and state and sales. Now i want to create sale visual in power BI based on country and state. I wanted to create a Country and state parameters, State parameter should be selected based on Country value selected. I…
0
votes
1 answer

Azure ADX: .alter-merge workload_group - failed

I searched the docs and used the example within: azure docs alter-merge-workload-group .alter-merge workload_group default ``` { "MaxExecutionTime": { "IsRelaxable": false, "Value": "00:01:00" } } } ``` This throws an…
0
votes
2 answers

Backfill in ADX using effectiveDateTime which is dependent on the data currently being loaded

So here is the scenario: We have a m_reading table in which we will ingest 24 readings every day. Out of 24 readings, 23 are of current day whereas 1 is of previous day. materialised view is supposed to aggregate the days data. Business user is…
Dhaval Shah
  • 968
  • 11
  • 12
0
votes
0 answers

ADX: how can I recover data from Azure Data Explorer after accidental deletion?

I know that I cannot perform the backup of data in Azure Data Explorer. How can I restore the data if accidental deletion of data happens? If I want to restore the data from last week or day for example how can I do it?
user422688
  • 597
  • 2
  • 10
  • 20
0
votes
0 answers

How to implement addition and multiplication for 256-bit unsigned integer using Intel's ADX intructions?

I need to do arithmetic operations on 256-bit unsigned integer and I need a fast implementation. AFAIK, SIMD instructions do not help because of carry propagation (Can long integer routines benefit from SSE?) and Intel's ADX instructions can…
phqb
  • 351
  • 3
  • 14
0
votes
1 answer

How to insert current timestamp value into kusto table using inline command

I am trying to insert current timestamp value into KUSTO table using now(), its not working as the inline command doesn't support functions or variables. Is there any way I can insert current timestamp value into KUSTO table.
0
votes
1 answer

Stop ingestion into ADX

We have an adx cluster that had multiple source ingestion tables. We have deleted on of these tables and its corresponding mapping, but now receive countless ingestion errors of the cluster looking for this table. Does anyone know of the proper way…
0
votes
1 answer

I want to generate 24 hour data(by filtering the date column to 24 hours) in KUSTO by adding custom start time and endtime values

I have date and status values in a table, i want to select the date range for a period of 24h, I want to get all the status values including starting and ending date values. But those values were not present in the table. It has to get it from…
0
votes
1 answer

The requested endpoint 'https:///v1/rest/mgmt' does not exist

I created a new cluster in Azure and using python api, I want to create a database and tables inside it. However, it gives me error that my cluster endpoint does not exists. Error: The requested endpoint 'https:///v1/rest/mgmt' does not…
0
votes
1 answer

How to select and drop empty rows in ADX (KQL)

I can not find any documentation on how to view and drop fully empty rows from an ADX source table. Using where field == "" doesn't return what we are looking for, and the microsoft docs don't provide much insight. Does anyone know any ways to maybe…
0
votes
1 answer

Can Synapse Spark connect to a "Log Analytics workspace"?

I need to export from "Log Analytics workspace" to storage account in parquet / delta format. How can I achieve this? Using the ADX Spark connector in a Notebook, it says that the URL is invalid. I’m using the URL of LAW instead of a cluster of…
0
votes
1 answer

Dropping an adx table with the azurerm terraform provider

How does one drop an adx table using the azurerm terraform provider? It seems like an intentional exclusion, so I wonder if I'm missing something fundamental here. I tried doing the following: resource "azurerm_kusto_script" "drop_old_table" { …