Saveen Reddy shows how to create a tally (or numbers) table in U-SQL:
Many common scenarios for U-SQL developers require constructing a RowSet made up of a simple range of numbers or dates, for example the integers from 1 to 10. In this blog post we’ll take a look at options for doing this in U-SQL. In the process, we’ll get a chance to learn how to use some common U-SQL features:
-
Creating RowSets from constant values
-
Using CROSS JOIN
-
Using SELECT to map integers to DateTimes
-
Using CREATE TABLE to create a table directly from a RowSet. This is sometimes called “CREATE TABLE AS SELECT” and often abbreviated as “CTAS“.
Click through to learn more.