Hi @PrernaU  It would help members of the community who are inclined to do so offer you possible answers to your question if you posted which distribution you are using. If this is indeed on Cloudera Data Platform, are you using Public Cloud (i.e., on AWS or Azure, for example) or Private Cloud (on premises installation)?     ... View more

@Sam7 No, you don't have to start a new question, just go ahead and post your screen shot of the query in Hue and the resulting error message and I'll revise the label for you if it's necessary. Also, let us know what distribution you're using and what version of Hue you're running, that would help us help you a lot.     ... View more

Hi @Yogesh771  It would help members of the community in offering possible answers to your question if you posted a link to the tutorial you are presumably following which includes the source code for this python program, describes how to run it and what the expected output is.     ... View more

@Sam7 DAS is Data Analytics Studio, which was the label you originally applied to your post. See the following partial page shot: So that is why @balajip was asking if the query was working fine before you made the latest change to capitalize the initial letter.  DAS is a completely different tool than Hue.   It would help members of the community in offering possible answers to your question if you could post a screen shot of the query you're submitting in the actual tool you are using as well as the error message that tool is returning when it attempts to execute the query.     ... View more

Hi @migration    What .jar files are these classes packaged in for cdh5.16? Can you share the relevant file names?     ... View more

Yes. You can allocate more of the host machine's RAM to the virtual machine. Take your current setting for that configuration, double it, then perform the same query against the same data set and compare the result. I also strongly recommend a close reading of Deploying Hortonworks Sandbox on VMWare     ... View more

I am following up here on one part of the original question, regarding the Apache Sqoop project being retired, just for the record (which is to say for the benefit of people who might arrive at this thread via search engine at some point in the near-to-medium term future).   I still stand behind what I previously wrote about the relative strengths/weaknesses of using these two tools to extract data from SQL server and ingesting it to hdfs, but I do want to clarify that while Sqoop was moved to the Apache Attic in June 2021, the software will continue to be supported by Cloudera and shipped as part of CDP Public Cloud and CDP Private Cloud.   See Cloudera's statement of support on this matter here: Apache Sqoop Support on Cloudera Data Platform     ... View more

I am following up here on one small point, just for the record (which is to say for the benefit of people who might arrive at this thread via search engine at some point in the near-to-medium term future). The original question from @vbar  included this: However, here's where it gets tricky. Sqoop was official [sic] retired this June and after that I don't really know if I am supposed to get prepared for a sqoop question or a "JDBC" format question. I can't speak at all to the question of whether or not the exam will have questions on Sqoop, but I do want to clarify that while Sqoop was moved to the Apache Attic in June 2021, the software will continue to be supported by Cloudera and shipped as part of CDP Public Cloud and CDP Private Cloud. See Cloudera's statement of support on this matter here: Apache Sqoop Support on Cloudera Data Platform     ... View more

Hi @Jaspal  The more detail you provide the better community members can assist with your question. I think you'll need to provide a tad more detail about what you mean when you say you "… want to mask these data sources" or "mask Hive tables". What does the result look like when you have the "mask" you desire in place?     ... View more