can you create a new issue and attach the logs. it is hard to see what is going on without logs. One way to check this is to first issue an explain query that will show you the druid query then you can copy that query and try it your self via curl command. ... View more

FYI Derby is a local instance DB used only for testing. For production please use Mysql or Postgres. ... View more

Concerning the DIY I cannot provide an exact answer but it is more a case by case I guess. From Druid perspective generally speaking Druid only uses Ambari to manage configs, therefore, it is doable to drop in some jars or update the HDP package only but this needs some level of testing to make sure nothing is breaking between versions. ... View more

@Roshan Dissanayake 1- keep in mind that the indexes have some extra overhead thus technically speaking some part of the data will be replicated but in a form of index thus compressed and more concise. 2- Hive will not manage the lifecycle of druid indexes you need to setup some Ozie (or any another workflow manager) to do the create table / insert into statements or drop table to keep the indexes up to date. 3- on a side not sure how the updates lands in your hive system, but if your pattern is mostly append/insert over a period of time then druid is designed for that usecase since data will be partition using time column. ... View more

Thanks yes we will update the Wiki. Am not 100%, but I hope this will make it to 2.6.3, we are pushing it to the finish line. Thanks. ... View more

Not sure what is the final use case, but one way to do this is: hive> CREATE TABLE foo (bar CHAR(8)); hive> insert into foo values ("00008DAC"); hive> select * from foo; OK 00008DAC ... View more

can you start a new thread and add more information about the install process and the stack trace ? ... View more