Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.3.0
-
None
-
Reviewed
-
HIVE-300. DISTRIBUTE BY now supports expressions. (zshao)
Description
We should support this kind of query. Distribute By only generates the hash-code, so it's easy to allow expressions (while it will be hard for Sort By and Cluster By).
SELECT a.key, a.value FROM a DISTRIBUTE BY rand()