question

SubhodeepChakraborty-1896 avatar image
0 Votes"
SubhodeepChakraborty-1896 asked SaurabhSharma-msft edited

Data Lake Analytics -Output filenames

Hey, what I wanted to append the current timestamp to filename while writing in U-SQL. But when I am doing it, PT time is being appending instead of EST.

Take a look-

OUTPUT @test1
TO @test_destination+ "Genesys_TR/Genesys_TR_"+@now.ToString("dd-MM-yyyyThh:mm:ss")+".csv"
USING Outputters.Csv( outputHeader: true, encoding : Encoding.Unicode);

result i am getting -

66910-image.png


azure-data-factoryazure-data-lake-analytics
image.png (21.2 KiB)
· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@subhodeepchakraborty-1896 Thanks for using Microsoft Q&A !!

Where is your data lake server located ? Also, are you using DateTime.Now ? If yes, What's the time you are seeing when submitting the job ?
67251-image.png
With dateTime.now I am seeing the same time
67208-image.png


0 Votes 0 ·
image.png (6.2 KiB)
image.png (7.0 KiB)
image.png (6.4 KiB)

Hi,

Yes I'm using DateTime.Now.
Server is located at East US 2

see the details below -

Job Submitted time-
67430-image.png

Output -
67483-image.png


0 Votes 0 ·
image.png (32.5 KiB)
image.png (55.6 KiB)
SaurabhSharma-msft avatar image SaurabhSharma-msft SubhodeepChakraborty-1896 ·

@SubhodeepChakraborty-1896 strange, can you please share the script how you are calculating @now variable in your case ? Is it only - DECLARE @now DateTime = DateTime.Now;
in your case ?
Also, In which region your resource group is ?
Here is document for your reference - C# Functions and Operators (U-SQL)


0 Votes 0 ·

@subhodeepchakraborty-1896 Can you please share the required information to mentioned Email Id I have shared with you in private messaging.

0 Votes 0 ·
Show more comments

Hey Saurabh, I can't find the private notes anywhere.
and also i can't share the subscription id as i am a contractor working for a client.

thanks for following up though!

But yes i can share one demo script that i was running.

0 Votes 0 ·
SaurabhSharma-msft avatar image SaurabhSharma-msft SubhodeepChakraborty-1896 ·

@subhodeepchakraborty-1896 So, you have the email address where to send your scripts ? right ? Please let me know if you don't have that ?

0 Votes 0 ·

@subhodeepchakraborty-1896 I am still waiting for your email. Can you please share your whole script over an email to azcommunity[at]microsoft[dot]com with your subscription id, Cluster Name, Cluster Region and with this Q&A thread link having subject as "Attn: Saurabh' so that I can take a look.

0 Votes 0 ·

0 Answers