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...
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.

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.

  • jashfabric's avatar
    jashfabric
    Helper II
    2 years ago

    Thanks Anonymous 
    That helps.