Giving Hadoop a Microsoft-class UI with HDInsight and Datameer

I'm only 22 minutes into the video, and I am amused that I heard Jason Bourne when they were discussing @json, '$.Born', !
I LOVE how he is doing the examples! I like that most typical use cases with increasing difficulty get covered one by one. Great intro video. Well done!
What shortcut to converts the JSON single line result into formatted JSON?
Can somebody please help me out in What shortcut to converts the JSON single line result into formatted JSON?
Great tutorial, at a perfect pace.
Thank you
@Celso:Use Sql Operations Studio. It works there.
a
Code :-
--------------------------------------
DECLARE @Json NVARCHAR(MAX) = '
[
{
"RigthNumber":"RC01","RowVersion":[0,0,0,0,0,87,205,88]
},
{
"RigthNumber":"RC02","RowVersion":[0,0,0,0,0,87,205,89]
}
]
'
SELECT RigthNumber
,RowVersion
FROM
OPENJSON (@Json)
WITH (
RigthNumber varchar(50) '$.RigthNumber'
,RowVersion timestamp'$.RowVersion'
)
Current OutPut (Wrong Data in RowVersion)
-------------------------------------------
RigthNumber RowVersion
RC01 0x
RC02 0x
Expected OutPut
-----------------
RigthNumber RowVersion
RC01 0x000000000057CD8C
RC02 0x000000000057CD8D
Query : i dont get proper data for timestamp data type,can you help me?
datatype of RowVersion is timestamp
Very good explanation. Thanks.
These demos worth the whole TSQL documentation about JSON