@mkumar13  how can we move data older than 2 years to ARCHIVE? ... View more

Hey @Mukesh Kumar, so i assume the service zeppelin was not running was the issue . i thought i asked you about it in last comment 🙂 Glad that it resolved. ... 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

hello i hit the same error and ambari-server.log shows "ERROR [ambari-client-thread-25] HostImpl:1374 - Config inconsistency exists: unknown configType" ... View more

@Mukesh Kumar - Login to your Ambari DB. For example postgres then: # psql -U ambari ambari Password for user ambari: bigdata - Then run the following queries to completely remove the Zookeeper service from DB. delete from hostcomponentstate where service_name = 'ZOOKEEPER'; delete from hostcomponentdesiredstate where service_name = 'ZOOKEEPER'; delete from servicecomponentdesiredstate where service_name = 'ZOOKEEPER'; delete from servicedesiredstate where service_name = 'ZOOKEEPER'; delete from alert_current where history_id in (select alert_id from alert_history where service_name = 'ZOOKEEPER'); delete from alert_notice where history_id in (select alert_id from alert_history where service_name = 'ZOOKEEPER'); delete from alert_history where service_name = 'ZOOKEEPER'; delete from alert_grouping where definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_history where alert_definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_current where definition_id in (select definition_id from alert_definition where service_name = 'ZOOKEEPER'); delete from alert_definition where service_name = 'ZOOKEEPER'; delete from alert_group_target where group_id in ( select group_id from alert_group where service_name = 'ZOOKEEPER'); delete from alert_group where service_name = 'ZOOKEEPER'; delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZOOKEEPER'); delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'ZOOKEEPER'); delete from serviceconfig where service_name = 'ZOOKEEPER'; delete from requestresourcefilter where service_name = 'ZOOKEEPER'; delete from requestoperationlevel where service_name = 'ZOOKEEPER'; delete from clusterservices where service_name ='ZOOKEEPER'; delete from clusterconfig where type_name like 'zookeeper%'; delete from clusterconfigmapping where type_name like 'zookeeper%'; - Now restart ambari server: # ambari-server restart . Additionally the 500 error for the API call "POST method for API: /api/v1/stacks/HDP/versions/2.5/recommendations." indicates a DB inconsistency. So if it is a fresh cluster then or if you do not want to have any service installed to is and move to the very initial state of ambari installation then better to perform an ambari reset instead of deleting services from ambari UI (As we see you only have zookeeper installed there) # ambari-server reset . *NOTE:* It is always recommended to keep a DB dump as a backup before making any manual DB changes. ... View more

Do you have any idea regarding this GPU database Planner? Basically in GPU Database operations, the planner checks for different scan and join methods, and then find the cheapest one and creates a query plan tree. While going for same thing in GPU, the checks should also be made for, whether it is device executable or not and the query plan tree from CPU has been updated. I just wanted to know in higher level and just for knowledge. I am just curious about this planning factors in GPU. There can be more than one appropriate paths in query plan tree. How the decision for particular path has been made considering those planning factors? ... View more

Thanks @lgeorge for your response. i have tried with and without new consumer and same error message. ... View more

yes @Mukesh Kumar provided that. thank you for your help. ... View more

Thanks for the update @Mukesh Kumar. Is it worth doing a 1-1 write or do you want to explore the BulkLoad option in Cassandra? ... View more