You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/02/10 07:54:36 UTC
[GitHub] [incubator-doris] IanWatsons opened a new issue #2873: [Bitmap
Index] can't create index with order"alter table add index using bitmap"
IanWatsons opened a new issue #2873: [Bitmap Index] can't create index with order"alter table add index using bitmap"
URL: https://github.com/apache/incubator-doris/issues/2873
**Describe the bug**
Doris can't create index with order"alter table table_name add index using bitmap"
**To Reproduce**
Steps to reproduce the behavior:
1. create table:
CREATE TABLE table_for_bitmap
(
siteid INT DEFAULT '10',
varchar_date VARCHAR(32),
pv BIGINT SUM DEFAULT '0'
)
AGGREGATE KEY(siteid,varchar_date)
DISTRIBUTED BY HASH(siteid) BUCKETS 10;
2. add bitmap index with order:
ALTER TABLE table_for_bitmap ADD INDEX index_name USING BITMAP (siteid) COMMENT 'balabala';
3. See error
ERROR 1064 (HY000): Syntax error at:
ALTER TABLE solo ADD INDEX index_name USING BITMAP (siteid) COMMENT 'balabala'
^
Encountered: USING
Expected
**Screenshots**
If applicable, add screenshots to help explain your problem.
**Additional context**
You can create bitmap index with order:
"ALTER TABLE table_for_bitmap ADD INDEX index_name (siteid) COMMENT 'balabala'; "
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] yangzhg commented on issue #2873: [Bitmap Index]
can't create index with order"alter table add index using bitmap"
Posted by GitBox <gi...@apache.org>.
yangzhg commented on issue #2873: [Bitmap Index] can't create index with order"alter table add index using bitmap"
URL: https://github.com/apache/incubator-doris/issues/2873#issuecomment-584456355
the syntax you using is invalid the right syntax likes `ALTER TABLE table1 ADD INDEX index_name (siteid, citycod) [USING BITMAP] COMMENT 'balabala';`
you can refer to https://github.com/apache/incubator-doris/pull/2573
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org