Forum Discussion

jashfabric's avatar
jashfabric
Helper II
2 years ago
Solved

SQL statement in Warehouse

Hi all
I am trying to execute a SQL query in Warehouse. But I am getting an error.

 

 

SELECT 
  d.ExpectedDate,
  COALESCE(x.Rate, NULL) AS Rate,
  x.Currency
FROM (
  SELECT TOP (SELECT COUNT(DISTINCT Date) FROM TABLE1) 
         DATEADD(day, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)), '1970-01-01') AS ExpectedDate
  FROM sys.tables 
  WHERE object_id = OBJECT_ID('TABLE1')
) AS d
LEFT JOIN TABLE1 x ON d.ExpectedDate = x.Date
ORDER BY d.ExpectedDate;

 

 



The query references an object that is not supported in distributed processing mode.
Msg 13426, Level 10, State 4, CODE LINE 1


What did I miss? Appreciate your help.


data warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jashfabric 
    Thanks for using Fabric Community.
    The error The query references an object that is not supported in distributed processing mode indicates that you've used an object or function that can't be used while you query data in Microsoft Fabric Warehouse.
    Fabric Warehouse uses distributed processing for performance, but some objects and constructs aren't supported in this mode. The error message indicates that your query references an unsupported object, likely sys.tables.

     

     

     

    You can refer to this link for more information: Link1

    Hope this helps. Please let me know if you have any further questions.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jashfabric 
    Thanks for using Fabric Community.
    The error The query references an object that is not supported in distributed processing mode indicates that you've used an object or function that can't be used while you query data in Microsoft Fabric Warehouse.
    Fabric Warehouse uses distributed processing for performance, but some objects and constructs aren't supported in this mode. The error message indicates that your query references an unsupported object, likely sys.tables.

     

     

     

    You can refer to this link for more information: Link1

    Hope this helps. Please let me know if you have any further questions.