sunbuhui · February 22, 2021 09:27
diff --git a/Hive sql: divide rows by their id(primary key), then sort them by group b/Hive sql: divide rows by their id(primary key), then sort them by group
 ```
 device_id rank
 12 1
 12 2
 12 3
 10 1
 10 2
 ```
 Then use the sql below
 ```
 select
  device_id,
  rank
 from 
  table
 distribute by
  device_id
 sort by
  rank
 ```
 Also, I don't know what's the difference between ``distribute by``,``group by``,``cluster by``, later I will create another gist about it
	```
	device_id rank
	12 1
	12 2
	12 3
	10 1
	10 2
	```
	Then use the sql below
	```
	select
	device_id,
	rank
	from
	table
	distribute by
	device_id
	sort by
	rank
	```
	Also, I don't know what's the difference between ``distribute by``,``group by``,``cluster by``, later I will create another gist about it