Azure machine learning - Trying to use an analytical function from SQLite results in error

Felipe Fritzen 1 Reputation point
2020-09-24T19:59:36.63+00:00

When trying to use the LAG function from SQLite on an Apply SQL Transformation module from Azure Machine Learning designer results in a error, saying the sintax near "(" was wrong.

The SQL code:

select t1.id, t1.veiculo, lag(t1.id) over (partition by t1.veiculo order by t1.id) id_ant
from t1

Looking at the link below, there is no clue on why I can't use a analytical function from SQLite on the module.
https://video2.skills-academy.com/en-us/azure/machine-learning/algorithm-module-reference/apply-sql-transformation

Any tips?

Azure SQL Database
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,960 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. YutongTie-MSFT 52,776 Reputation points
    2020-09-28T00:27:09.423+00:00

    Hi Felipe,

    Have you tried to put default and offsite variable in to see if work or not?

    Like this,
    LAG (scalar_expression [,offset] [,default])
    OVER ( [ partition_by_clause ] order_by_clause )

    Please let me know if that still not working.

    Regards,
    Yutong

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.