U-SQL Built-In Types

Question

U-SQL Built-In Types

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
January 31, 2017 at 12:10 am

#77585

Comments posted to this topic are about the item U-SQL Built-In Types

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287024 More actions · Answer 1

I learned something new today, so thanks. I looked at the percentage of respondents who have gotten it right and surmise that others did the same research, reading and learning I did. I suppose the other possibility is that I'm among the last individuals who haven't used U-SQL yet. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Mr. Brian Gale SSC-Insane Points: 24689 More actions · Answer 2

Ed Wagner - Tuesday, January 31, 2017 5:42 AM
I learned something new today, so thanks. I looked at the percentage of respondents who have gotten it right and surmise that others did the same research, reading and learning I did. I suppose the other possibility is that I'm among the last individuals who haven't used U-SQL yet. 😉

heh... I've not used U-SQL yet either, but I thought most of those were not complex data types. only the SQL.% ones were and then it was a guess on 2 out of the 3... I'd at least be half right :). Got it correct then read about it.
With the QOTD's, I tend to look at the question, guess on the answer then read the provided links (even if I was correct). I do the research after answering the question. I think of it kind of like a question on a test; you are given the test and a set of answers and if you looked things up online, you'd fail.
The bad part about my method is that I miss out on a lot of points.
I did like the question though. I've not used U-SQL and I think I should learn it better soon. Just looked it up and found a question on stack overflow about it and I realized I know nothing of U-SQL. Mind you, reading the fourm posts here, I sometimes wonder if I even know T-SQL LOL.

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Revenant SSC-Forever Points: 42467 More actions · Answer 3

I guess I am one of the few who work with Data Lake. Thanks, Steve!

TomThomson SSC Guru Points: 104773 More actions · Answer 4

bmg002 - Tuesday, January 31, 2017 7:24 AM

heh... I've not used U-SQL yet either, but I thought most of those were not complex data types. only the SQL.% ones were and then it was a guess on 2 out of the 3... I'd at least be half right :). Got it correct then read about it.

Well, I started from where you did, but it seemed obvious that no-one with their head screwed on would want SQL.HIERARCHY and I didn't think Ms was sufficiently stupid to pick that one over either of the others. Mind you, that was a close thing with SQL.MAP being in there, because it strikes me as OO rather than RO (but the idea of SQL.HIERARCHY strikes me the same way, but much harder, so ...)

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Ed Wagner - Tuesday, January 31, 2017 5:42 AM
I learned something new today, so thanks. I looked at the percentage of respondents who have gotten it right and surmise that others did the same research, reading and learning I did. I suppose the other possibility is that I'm among the last individuals who haven't used U-SQL yet. 😉

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events