Re: Re: [Questio]Which record does Hive give the bigger number when I use row_number

2017-10-12 Thread 孙志禹
#yiv2801412653 body {line-height:1.5;}#yiv2801412653 blockquote {margin-top:0px;margin-bottom:0px;margin-left:0.5em;}#yiv2801412653 body {font-size:11pt;color:rgb(0, 0, 0);line-height:1.5;}#yiv2801412653 body {font-size:11pt;color:rgb(0, 0, 0);line-height:1.5;}Thanks a lot! It helps me so much.

Re: [Questio]Which record does Hive give the bigger number when I use row_number

2017-10-11 Thread Furcy Pin
Hello, Either one can receive the bigger row_num, in an underteministic fashion (which is NOT equivalent to random). Simply put, it will be whichever is treated last by Hive, which you have no way to know. If your two rows differ on other columns, you might want to add them to your ORDER BY claus