... you have to adapt the configuration to your needs, of course, by changing metastore host and warehouse dir, accordingly ... View more

Perfect its worked ... View more

Using the smae example od data, I've got something like that in my result, trying to have details of one or more than one partition with (desc formatted operation)     The problem here si that each time I've got only information about one and only one partition, even if I'm specifying two or three.  Do you know please how HIVE behave in this case ? Is it a bug ?    Thank you   ... View more

Thanks Deepesh and Divakar ... View more

So indeed it was a corrupted client, in that case please accept my first answer. ... View more

@Félicien Catherin The tutorial has typo... you need to create normal table first using following sytax: CREATE TABLE FIREWALL_LOGS( time STRING, ip STRING, country STRING, status INT ) CLUSTERED BY (time) into 25 buckets ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LOCATION '/tmp/server-logs' TBLPROPERTIES("transactional"="true"); Once the above table is created you can convert it to ORC CREATE TABLE FIREWALL AS STORED AS ORC SELECT * FROM FIREWALL_LOGS; ... View more

Yes, metadata does store the columns name in its database. hive > show columns in table_name: hive> set hive.cli.print.header=true; To view the column names of your table. ... View more

Thank you! ... View more

It worked for me to change the database to mysql. 1.you need to create user and databases named 'superset' using mysql shell GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' IDENTIFIED BY '*****' WITH GRANT OPTION; create database superset; 2. change the config for Druid , set Mysql's hostname port user password .etc 3. start the druid, and it worked! ... View more

> I have millions of records in each table and hundreds of tables, so first option might not be optimal for big tables. > will try out the other options thank you ... View more