Details
-
Bug
-
Resolution: Unresolved
-
Major
-
Columnar 1.0.0
-
Untriaged
-
0
-
Unknown
Description
1. The below query throws the following error but creates an empty collection named col2.
Create collection col2 primary key (movie_id : uuid) as SELECT m._id AS movie_id, m.title AS movie_title, COUNT(c._id)AS num_comments FROM movies m LEFT JOIN comments c ON m._id = c.movie_id GROUP BY m._id, m.title ORDER BY num_comments DESC;
|
error:
[ { "code":23069, "msg":"Field type object cannot be promoted to type uuid" } ] |
2. The below query throws the following error but creates an empty collection named col4.
Create collection col4 primary key (movie_id : String) as SELECT m._id AS movie_id, m.title AS movie_title, COUNT(c._id)AS num_comments FROM movies m LEFT JOIN comments c ON m._id = c.movie_id GROUP BY m._id, m.title ORDER BY num_comments DESC;
|
error:
[ { "code":23069, "msg":"Field type object cannot be promoted to type string" } ] |