@GangWar  It worked. Thanks ... View more

Hi @Asef23  I believe that the following thread might be helpful for you to follow in order to get more info about this issue: Hortonworks Repositories can't be accessed   Hope this helps     ... View more

@Kjafarov As I understand from this post: Cloudera Manager will continue to run either fully features or with the Cloudera Express feature set for some Cloudera Manager 6 versions. …yes, it is possible to continue to use the Cloudera Express edition circa CDH6. The only recent change was that Cloudera moved the binaries it distributes from public repositories into private repositories. And again, the announcement I linked to above has links in it to documentation describing in detail how to install CDH and other software from Cloudera’s private repositories. This means if you're trying to install on a new cluster using Cloudera's public repositories as a source for the packages, that installation would fail. It does not mean that it is now impossible to use the Cloudera Express edition from the CDH6 era.   Hope this helps.     ... View more

It is not recommended to update ambari DB directly but as in this case the cmd 'ambari-server update-host-names host_names_changes.json' is not a much help, we can perform below actions by taking ambari DB back up. I tested and it worked.   Note: Please take DB backup! and PLEASE only do at your own risk.   In this case, the new host_name is ambarinn.cluster.com and new name is ambarinn261.cluster.com We need to concentrate on the host_name that says healthStatus":"UNKNOWN".   Steps to resolve: ambari-agent and ambari-server successfully stopped [root@ambarinn261 ~]# su - postgres Last login: Wed Jan 27 13:14:40 EST 2021 on pts/0 -bash-4.2$ psql psql (9.2.24) Type "help" for help. postgres=# \c ambari You are now connected to database "ambari" as user "postgres". ambari=# select host_id,host_name,discovery_status,last_registration_time,public_host_name from ambari.hosts; host_id | host_name | discovery_status | last_registration_time | public_host_name ---------+-------------------------+------------------+------------------------+------------------------- 201 | ambarinn261.cluster.com | | 1611772466200 | ambarinn261.cluster.com 1 | ambarinn.cluster.com | | 1611768543457 | ambarinn.cluster.com (2 rows) ambari=# select * from ambari.hoststate; agent_version | available_mem | current_state | health_status | host_id | time_in_state | maintenance_state -----------------------+---------------+---------------+----------------------------------------------+---------+---------------+------------------- {"version":"2.6.1.5"} | 279948 | INIT | {"healthStatus":"HEALTHY","healthReport":""} | 201 | 1611772466200 | {"version":"2.6.1.5"} | 2120176 | INIT | {"healthStatus":"UNKNOWN","healthReport":""} | 1 | 1611768543457 | (2 rows) ambari=# UPDATE ambari.hosts SET host_name='ambarinn261.cluster.com' WHERE host_id=1; ERROR: duplicate key value violates unique constraint "uq_hosts_host_name" DETAIL: Key (host_name)=(ambarinn261.cluster.com) already exists. ambari=# UPDATE ambari.hosts SET public_host_name='ambarinn261.cluster.com' WHERE host_id=1; UPDATE 1 ambari=# UPDATE ambari.hosts SET public_host_name='ambarinn261a.cluster.com' WHERE host_id=201; UPDATE 1 ambari=# UPDATE ambari.hosts SET host_name='ambarinn261a.cluster.com' WHERE host_id=201; UPDATE 1 ambari=# UPDATE ambari.hosts SET host_name='ambarinn261.cluster.com' WHERE host_id=1; UPDATE 1 ambari=# \q -bash-4.2$ exit logout [root@ambarinn261 ~]# ambari-server start       ... View more

@Arna you don't say what cost you want to be lower than, so I'll assume that you're trying to avoid cloud service provider costs.   If you're looking for a solution that would allow you to run the CDP Data Center 60-day trial on your own, local machine, consider @carrossoni 's Vagrant and Virtualbox-based approach, which you can read about here: How to create a Centos7 CDP-DC Trial VM for sandbox/learning purposes   ...hope this helps.     ... View more

Thanks, you saved my day. Its also useful for merging multiple json files in a single jsonlines file. cool!! ... View more

I am with you too.  I am able to get the Hortonworks 2.5 version working without any problem.  Others versions after 2.5 are consistently behaving the same way.   The VM itself comes up fine - with the splash screen.   When I try connecting to this VM using the browser and the URLs (have tried various combinations, localhost, specific IP address, ports 4200,1000,1080, etc), the connection is unsuccessful.   I can get to the command prompt using the Alt+Fn_F5 screen.  I can login successfully with the root/hadoop combination.  It does not ask me to change the password the first time I login.     From within this shell, almost no command works.  I have tried 1. ifconfig 2. hadoop version 3. hive and a host of others.  A command not found message is what greets me.   From going through many articles, I understand, the later versions of the VM (after 2.5) are running these deamons inside a doctor and we have to connect to it?  I tried running a few "docker" commands and based on my little research, find that there is no docker container running inside this VM, at least by default.   I am stuck.   Any help is appreciated.   Thanks, Sriram ... View more

Hi @calonsca! Please have a look at this spec as well! [ { "operation": "shift", "spec": { "@": "data", "ID": "&", "#${date}": "date", "#${dataset:toLower()}": "dataset" } } ] ... View more