CREATE TABLE table2 ( bigint_col BIGINT, string_col TEXT ENCODING DICT(32)); SELECT lpad("string_col", 10, 'a') AS tmp FROM table2; SELECT rpad("string_col", 10, 'a ...