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
1
vote
2 answers

Partition an unpartitioned table in ADX

I have a table where we don't have a partition policy. Data is ordered based on the ingestion time. When I went through this blob post https://yonileibowitz.github.io/blog-posts/data-partitioning.html#backfill-or-unordered-ingestion I realized…
Justin Mathew
  • 950
  • 8
  • 34
1
vote
1 answer

How to I expand JSON data in kusto/data explorer that has nested data?

I am trying to ingest JSON array data into Azure data explorer, as per this Microsoft article. (Only the JSON Array section) https://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats?tabs=kusto-query-language I have one table with…
kalpana
  • 83
  • 1
  • 13
1
vote
1 answer

Kusto functions migration to upper environment

I have several functions on the dev ADX environment. Now I need to migrate all of them into upper environment. Is there any handy commands to export all available functions from one environment to another. I tried to export all functions as csv…
Justin Mathew
  • 950
  • 8
  • 34
1
vote
2 answers

Kusto data ingestion from an Azure Function App ends with a 403

I try to ingest data from azure function app into a ADX database. I followed the instruction found in the the article here. The difference is, I'd like to insert data into the table. I struggle with a 403 error "Principal 'aadapp=;' is not…
Jean
  • 11
  • 4
1
vote
1 answer

adx calculation to custom columns from a matrix rather than the default HLC

I have a matrix with stock prices and various other data. it is not the ordinary yahoo download therefore the titles for open, high, low and close are different. I want to apply adx <- adx(HLC(x),10) however by default the adx function uses the HLC…
np2000
  • 37
  • 5
1
vote
2 answers

ADX function result incorrect in r

When I use the ADX function, I'm not getting the correct answer. For example, the ADX(14) value from 10/4/2017 is 12.87. The code below gives me 9.53. Any ideas why this is off? require(quantmod) tickers<-c('SPY') getSymbols(tickers,…
S Novogoratz
  • 388
  • 2
  • 14
1
vote
1 answer

Directory listing in IBM 4690 CBASIC

I'm looking for the correct ADX call to perform a directory listing of a Controller drive. From the IBM programming guide, I see ADX_TDIR, which is for terminals, is there a variant for controller program?
user1168037
  • 120
  • 6
1
vote
1 answer

How to design an Average Directional Movement Index Expert Advisor in MQL4/5?

I have a trading strategy based on ADX, in a simplest way I enter when ADX is above 30 both on the 30 minutes and hourly chart. I need to create an EA in MQL5 just to give me a sound alert, when ADX has hit level 30 both on 30 minutes and hourly…
1
vote
0 answers

Google ADX Seller Rest API: get report by custom currency

I'm using Google ADX API to get revenues report by date range. By default I'm getting the revenues in ILS but I what to get the currency in USD or EUR and I don't want to use currency conversions like…
0
votes
0 answers

Azure Data Explorer Dashboard - Display for time zone showing selected time range (period)

As of today, to display the current time range selected in a dashboard is displayed like so: print strcat(format_datetime(datetime_utc_to_local(_startTime, 'Europe/Oslo'), 'yyyy-MM-dd [HH:mm:ss]'), " - ",…
Thomas
  • 1
0
votes
1 answer

Is there a way to stop Azure Data Explorer inferring the data types in an array?

I have a function that receives an array of values as a parameter, all those values it's supposed that be strings. let SelectedValues = dynamic(["2022-08-14T13:05:17Z", "EconChgOvrDiff", "1"]); let F = (SelectedValues:dynamic=dynamic([]),…
0
votes
1 answer

How to fill empty values in a column to the latest record value in KUSTO

I have a Date column and value column, I need to create a new column (Expected Date) with Date values w.r.t value column. The screenshot attached here has some sample data. Expected Date column will take the date when there is a value in the value…
0
votes
2 answers

How to send Json & Avro format events to Azure Event Hub and finally Ingesting them into Azure Data Explorer Table. Using .Net (c#)

My requirement is using Azure Event Hub to capture events in format Json and/or Avro format and finally ingesting those events into ADX. Also don't want to capture these events in to Blob storage etc and using Event Grid option on top of it. Want to…
0
votes
3 answers

Azure Function to be triggered when there is new data inserted in ADX

I have a usecase where the data is inserted in ADX via the Event Hub. I want to track the changes in ADX i.e. when ever there is a new data inserted in ADX i want my function to be triggerd. Also, whenever a new data is inserted in ADX, i want the…
harish
  • 3
  • 3
0
votes
1 answer

ADX update policy on follower

is it possible to have a update policy on a follower cluster in ADX, to write data to a new table in the follower cluster, when data in a leader table is ingested? Thanks!
mananana
  • 393
  • 3
  • 15