PIVOT support

[ghost]

Hi

I'm trying to run a USQL script in VS2017 that uses PIVOT but I'm getting:

Internal error! The method or operation is not implemented.

It's the PIVOT line that is causing it.

I have ADL Tools v 2.2.5000.0.

I notice it was released recently, too recently? 20-Feb-2017 Release Notes

AFAIK I'm running the latest version. Do I have to wait until a new version? What can I do to get this working?

PS. Not as important, but the ANY_VALUE function doesn't appear to be supported in this version either.

Thanks
Steve

[dagiro]

PIVOT works now in the portal. PIVOT should work in Visual Studio in the next release later this month.

[ghost]

Ok thanks

[ghost]

Hi, I'd like check up on this. I've updated VS2017 and again tried PIVOT and still get the same result. Is this part of the VS2017 update or should I look out for an extension? Is the update still coming?

In case it helps, here is my current VS2017 version:

Microsoft Visual Studio Enterprise 2017
Version 15.0.26228.10 D15RTWSVC
Microsoft .NET Framework
Version 4.6.01586
Installed Version: Enterprise
Azure Data Lake Tools for Visual Studio 2.2.5000.0

[dagiro]

Apologies. The revised tools have not yet been published so PIVOT will not work in Visual Studio when executing locally. The last word I heard, which was on 4/3, was "It should be shipping soon."

[ghost]

Ok thanks for posting and update.

[dagiro]

Finally! The updated tools are now available.
Thank you for your patience.

[capitanou]

After upgrading the VS tools for Azure Data Lake to version 2.2.6000.0. There seems to be a conflict with the cloud explorer version that breaks the ability to use the Azure Data Lake Explorer. The message received is "Azure Data Lake Tools is not installed. Download the latest version." Is any one else having this issue?

[MikeRys]

This is a known issue. Until a fix is released, we suggest that you use the Server Explorer. Cheers Michael

…

________________________________ From: capitanou <notifications@github.com> Sent: Monday, April 17, 2017 8:21 PM To: Azure/usql Cc: Subscribed Subject: Re: [Azure/usql] PIVOT support (#76) After upgrading the VS tools for Azure Data Lake to version 2.2.6000.0. There seems to be a conflict with the cloud explorer version that breaks the ability to use the Azure Data Lake Explorer. The message received is "Azure Data Lake Tools is not installed. Download the latest version." Is any one else having this issue? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#76 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ALNzJBrVCRo13f0l1vdptQKViprEtHIpks5rw8nVgaJpZM4MahCV>.