Month: February 2015

Query of the century

My co-worker showed me this today and it’s just gorgeous.

BEGIN;
CREATE TABLE xyz_tmp (LIKE xyz INCLUDING ALL);
COPY xyz_tmp FROM STDIN;
ALTER TABLE xyz RENAME TO xyz_old;
ALTER TABLE xyz_tmp RENAME TO xyz;
DROP TABLE xyz_old;
COMMIT;

Hue with LDAP doesn’t start up after Cloudera Manager upgrade

Latest Cloudera Manager omit ldap_username_pattern entry from hue.ini build process.

Paste below into safety valve as a workaround.

[desktop]
[[ldap]]
ldap_username_pattern="username=,ou=user,dc=7979,dc=us"

P.S: Had some weird experience without “”