@saur  Any updates on this? ... View more

@focal_fossa  Can you share how method you used to extend you VM disk? Whats the VM disk file extension vmdk or vdi? Note virtualbox does not allow resizing on vmdk images.   Does you disk show Dynamically allocated storage as shown below?   Please revert  ... View more

@focal_fossa  AFAIK  these sandboxes dynamically allocated storage.  You can try that by  generate and load data for TPC-DS General usage is    tpcds-setup.sh scale_factor [directory]   For example below will generate  200 GB of TPC-DS data in /user/data [HDFS]   ./tpcds-setup.sh 200 /user/data     This should prove that the disk allocation is dynamic  see below links   https://github.com/hortonworks/hive-testbench/blob/hive14/tpch-build.sh and https://github.com/hortonworks/hive-testbench/blob/hive14/tpch-setup.sh to build   Hope that helps     ... View more

@rwinters  Simplest method is to edit /etc/postgresql/9.2/main/start.conf and replace auto with manual or disabled.   You can also resolve this by adding the following to the end of your shell's initialisation file (e.g. ~/.bashrc if you're using bash): PATH=/usr/psql-10/bin:$PATH reboot the server  now you should have the postgres 10 as the default Hope that helps ... View more

@tanishq1197    The Password should be the scm password Enter SCM password: The default is SCM that should progress successfully     ... View more

@Henry2410  MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. On the other hand, Snowflake is detailed as "The data warehouse built for the cloud".   There's not really an equivalence between MySQL and Snowflake use cases. What you are asking really is whether Snowflake can play the role of an OLTP database. Snowflake is not an OLTP database. It is an OLAP database. So generally speaking I would say no.   Snowflake is a cloud-based warehouse and it would be used most of the times for OLAP purpose back to your questions, Snowflake can be used under the following conditions: If you have only inserts into target table and not much updates to the table we can achieve good performance by using cluster by and other inline views Having said that, to explore your use case a little bit more I would ask yourself or your stakeholders the following questions: Do you need millisecond response times for INSERTs, UPDATEs, and SELECTs? Does your application tool require indexes? Does your application need referential integrity and uniqueness constraints enforced? If you said yes to ANY of 1, 2, 3 then go MySQL. If you said NO to ALL 1, 2, and 3, then Snowflake might be viable. But even then I would not recommend it, as that is not what Snowflake was built for. ... View more

@LeticiaAraujo  Log4j properties set the properties that control logging activities for each service running in your Hadoop cluster. This is something that every site can customize according to its needs like enabling DEBUG will generate detailed by huge logs is you want to analyze the issue with your service. Rotation of the logs, compression format or logfile size etc Logging services is a topic on its own, and here is a good source for reading log4j  the most common task is enabling DEBUG and Log rotation and it's date format. ... View more

@borisgersh  Sorry for your frustration neither I nor  the admin of this platform is responsible for the contents of the CCA175 exams, here we try to help maybe you will need to address your case to certification@cloudera.com I have found a Hadoop Developer Ashwin Rangarajan who has shared some good content  below  https://ashwin.cloud/blog/cloudera-cca175-spark-developer/   Hope that helps     ... View more

@LeticiaAraujo  That is the warning you should be able to continue, you will need adjust the log4j.properties.Having said that to switch to user hive from a root session you should do the following [root@sandbox-hdp ~]# su - hive Note the dash and space the above switch command change the context to the hive user variables. explanation su - invokes a login shell after switching the user and the login shell resets most environment variables, providing a clean base. su Just switches the user, providing a normal shell with an environment nearly the same as with the old use [root] ... View more

@tanishq1197    I think I did a typo error  previously there was an extra scm the below should run successfully  sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm   ... View more