Re: Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation

2018-07-17 Thread Tomas Vondra
On 07/11/2018 08:02 AM, Takao Magoori wrote: Hello, I have a table which has billions of rows and I want to select it by bitwise operation like, =# CREATE TABLE IF NOT EXISTS t_bitwise ( id INTEGER NOT NULL ,status_bigint BITINT NOT NULL ,status_bit BIT(32) NOT NULL ); =# INSERT IN

Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation

2018-07-10 Thread Takao Magoori
Hello, I have a table which has billions of rows and I want to select it by bitwise operation like, =# CREATE TABLE IF NOT EXISTS t_bitwise ( id INTEGER NOT NULL ,status_bigint BITINT NOT NULL ,status_bit BIT(32) NOT NULL ); =# INSERT INTO t_bitwise (id, status_bigint, status_bit) SELECT