RE: Using hiveSQL to find content
You are viewing a single comment's thread:
I was following to the top 3rd but I think I concede defeat in SQL! The queries we (you) made for HMRC will be my limit, this is next level wizardry!
0
0
0.000
Looking at different views/tables here with more filter criteria but if you know what the columns mean it's not so complicated. Glad you got started with a practical example though!
Yes, I think it's just a case of knowing the names of columns that are used to select the data - but you can find that just by looking in to the views in that SQL software you shared. Pretty happy we went through what we needed to - now we just need HIVE designed fountain pens and we'd be sorted 😃
Don't look at me as the seller, I cannot be arsed accounting for another income stream!
Hahaha! Stick to biro!