16 Tabular Model Partitions Bhaskar Reddy Baddam

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

Its not accepting normal sql query for partition. Validation error. Which type of query it will accept in the expression panel?

rajashekharb
Автор

Hi Bhaskar, I have watched all of your tabular learning videos, It's simple and great. Thanks for all these.
Only thing is your voice is very very low.

samitjena
Автор

I can bearly hear what you're saying and I'm at the highest sound setting... :( By the way, you should never use BETWEEN when specifying date ranges on datetimes. This is error-prone and you're not even aware that in your video you've already made a mistake. Datetime has a resolution of .003 sec, which means that, for instance, 20:59:59.999 is in fact converted behind the scenes into 21:00:00.000, which implies that it can---depending on your data---sometimes return the same rows in two different partitions. I don't have to tell you that it's WRONG.

dariuszspiewak