Data Lake Analytics -Output filenames

Subhodeep Chakraborty 21

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 -

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-12T02:35:21.537+00:00

@Subhodeep Chakraborty 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 ?

With dateTime.now I am seeing the same time
Subhodeep Chakraborty 21 Reputation points

2021-02-12T16:25:09.883+00:00

Hi,

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

see the details below -

Job Submitted time-

Output -
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-12T23:03:31.737+00:00

@Subhodeep Chakraborty 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)
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-16T22:23:06.877+00:00

@Subhodeep Chakraborty Can you please share the required information to mentioned Email Id I have shared with you in private messaging.
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-18T18:30:42.513+00:00

@Subhodeep Chakraborty I have not heard back from you. Are you able to look into my private messaging on this issue ?
Subhodeep Chakraborty 21 Reputation points

2021-02-18T18:39:16.067+00:00

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.
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-18T19:12:47.553+00:00

@Subhodeep Chakraborty So, you have the email address where to send your scripts ? right ? Please let me know if you don't have that ?
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-02-19T19:06:17.193+00:00

@Subhodeep Chakraborty 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.

Share via

Data Lake Analytics -Output filenames

Your answer