Cloudera Hadoop

This topic describes how to connect Tableau to a Cloudera Hadoop database and set up the data source. Refer to the Connecting to Cloudera Hadoop knowledge base article for more details about connecting to Hadoop data.
  1. Click Connect to Data.
  2. On the Connect page, click Cloudera Hadoop, and then do the following:
    1. Type the name of the server that hosts the database and the port number to use. If you are connecting using Impala you must use port 21000. This is the default port if you are using the 2.5.x driver (recommended).
    2. Select how to connect to the database. Depending on the version of Hadoop and the drivers you have installed, you can connect using one of the following:
      • Hive Server
      • Hive Server 2
      • Impala
      Note: For secure connections to Cloudera Hadoop, it is recommended that you use Hive Server 2. See Connecting to Hive server 2 in Secure Mode.
    3. Click Connect.
      If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
  3. On the data source page, do the following:
    1. (Optional) Click the default data source name at the top of the page, and then type a unique data source name for use in Tableau.
    2. From the Schema drop-down list, type the schema name in the text box, click the search icon, and then select the schema.
    3. Type the table name in the Table text box, click the search icon, drag the table to the join area, and then click Go to Worksheet to begin building the view. Alternatively, drag additional tables to the join area and use conditions to join them. You can choose to combine tables or use Custom SQL when you are working with multiple tables. You can also add joins later.
      Optionally, you can make the following configurations before building the view:
      • Preview the data – In the preview area, select Update Now to preview the first 10,000 rows of the data source. If you add tables, remove tables, or make changes to the join conditions, click Update Now. If you want changes to automatically reflect in the preview area, click Automatically Update.
      • Change data types – Change the data type of a column by clicking the data type icon.
      • Rename or hide columns – Rename or hide a column by clicking the column header drop-down menu and selecting the respective option.
      • Connect live or use an extract – At the top of the data source page, select a live or extract connection to the data source. If you choose to take an extract, an Edit link displays allowing you to set up filters that define a subset of the data to include in the extract.
      • Add data source filters – Add data source filters to restrict the visibility and use of the fields in the data source.

Initial SQL

When connecting to Cloudera Hadoop, you can optionally specify a SQL command that will be run once upon connection. See Initial SQL to learn more about adding these commands to your connection.

Hadoop and Impala

When connecting to Hadoop using Impala, the queries are limited to 100,000 rows of data when the query includes an ORDER BY clause. This limit can be configured either by modifying the "order-by-limit" value in the workbook xml or using a TDC customization such as <customization name="order-by-limit" value='10' />.

An example of a Cloudera Hadoop data source is shown below.

64 comments:

  1. Hi,
    good appearence of content data it's use ful to us and best institute provides best training on hadoop online training

    ReplyDelete
  2. Hi,
    Thanks for nice data provided easy way to learn training with real time on
    hadoop online training
    through the experienced experts

    ReplyDelete
  3. Thanks for Sharing.Very Useful Information.
    Hamsini Technologies is One of the Best Institute to Provide Online IT Trainings.
    We have Real-time Industry experts to provide Online,Classroom & corporate Trainings around the world.

    Contact us for more details .

    Hadoop Online training




    ReplyDelete
  4. Cloud is one of the tremendous technology that any company in this world would rely on(cloud computing training in chennai). Using this technology many tough tasks can be accomplished easily in no time. Your content are also explaining the same(Cloud computing training in chennai). Thanks for sharing this in here. You are running a great blog, keep up this good work.

    ReplyDelete
  5. Nice blog...Very useful information is providing by ur blog..here is a way to find Oracle Training In Chennai

    ReplyDelete
  6. i wondered keep share this sites .if anyone wants realtime training Greens technolog chennai in Adyar visit this blog..performance tuning training In Chennai and more Oracle Training In Chennai

    ReplyDelete
  7. once again sharing this informative blog .Datastage training In Chennai It uses a graphical notation to construct data integration solutions and is available in various versions may visit greens technology chennai in adyar Greens Technologys Training In Chennai

    ReplyDelete
  8. i gain the knowledge of Java programs easy to add functionalities play online games, chating with others and industry oriented coaching available from greens technology chennai in Adyar may visit.Core java training In Chennai

    ReplyDelete
  9. I have read your blog and I got very useful and knowledgeable information from your blog. It’s really a very nice article Greens Technologies Training In Chennai

    ReplyDelete
  10. fantastic presentation .We are charging very competitive in the market which helps to bring more oracle professionals into this market. may update this blog . Oracle training In Chennai which No1:Greens Technologies In Chennai

    ReplyDelete
  11. Excellent post, I agree with you 100%! I’m always scouring the oracle for new information and learning whatever I can, and in doing so I sometimes leave comments on blogs.Oracle Training In Chennai

    ReplyDelete
  12. There are lots of information about latest technology and how to get trained in them, like Best Hadoop Training In Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..

    ReplyDelete
  13. I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    SalesForce Training in Chennai

    ReplyDelete
  14. Pretty article! I found some useful information in your blog, it was awesome to read,thanks for sharing this great content to my vision, keep sharing..
    Unix Training In Chennai

    ReplyDelete
  15. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..
    Android Training In Chennai In Chennai

    ReplyDelete
  16. I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job.
    SAP Training in Chennai

    ReplyDelete
  17. Oracle Training in chennai
    Thanks for sharing such a great information..Its really nice and informative..

    ReplyDelete
  18. Selenium Training in Chennai
    Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    ReplyDelete
  19. Data warehousing Training in Chennai
    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..

    ReplyDelete
  20. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Websphere Training in Chennai

    ReplyDelete
  21. Oracle DBA Training in Chennai
    Thanks for sharing this informative blog. I did Oracle DBA Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..

    ReplyDelete
  22. Information which you provided on Hadoop Online Training is so impressive

    ReplyDelete
  23. Learning new technology would give oneself a true confidence in the current emerging Information Technology domain. With the knowledge of big data the most magnificent cloud computing technology one can go the peek of data processing. As there is a drastic improvement in this field everyone are showing much interest in pursuing this technology. Your content tells the same about evolving technology. Thanks for sharing this.

    Hadoop Training in Chennai | Best Hadoop Training in Chennai | Best hadoop training institute in chennai | Big Data Hadoop Training in Chennai

    ReplyDelete
  24. I have finally found a Worth able content to read. The way you have presented information here is quite impressive. I have bookmarked this page for future use. Thanks for sharing content like this once again. Keep sharing content like this.

    Software testing training in chennai | Software testing institute in chennai | Manual testing training in Chennai

    ReplyDelete
  25. Thank you for this wonderful information. It was really helpful.oracle dba training In Chennai

    ReplyDelete
  26. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon
    tableau desktop server training in Bangalore

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. hai!!!its nice to see your blog...Big Data Trunk is the leading Big Data focus consulting and training firm founded by industry veterans in data domain.We offer services like Strategy Consulting, Advisory Consulting and high quality classroom individual and corporate training. Once visit our blog and get a breif idea about Bigdata trunk...

    hadoop ónlinÉ training

    free big data bootcamp

    hadoop big data videos

    spark ónlinÉ training

    Big data QA Tester training

    Big data Analyst training

    ReplyDelete
  29. Cloud computing is preffered by most of the companies as this is cost effective and very fruitful, I'am using cloud for many days and I must say that it is very helpful.
    cloud computing training in chennai|cloud computing courses in chennai|cloud computing training|cloud computing training chennai|cloud training in chennai

    ReplyDelete
  30. Salesforce.com is an american company which offfers CRM based cloud services and it is loved globally for it quality services
    salesforce training in chennai|salesforce training institute in chennai | salesforce course in chennai

    ReplyDelete
  31. SAS stands for statistical analysis system which is a analysis tool developed by SAS institute and with the help of this tool data driven decisions can be taken which is helpful for the bsuiness.
    SAS training in Chennai | SAS course in Chennai | SAS training institute in Chennai

    ReplyDelete
  32. Thanks for sharing such a wonderful article on Hadoop. Through my friend, I got know one more good resource related to Hadoop. will give detailed knowledge on Hadoop. Just have a look at this link: https://intellipaat.com/big-data-hadoop-training/

    ReplyDelete
  33. Your blog is much effective and thanks for sharing information.. Here we are providing training & materilas and dumps for those who are preparing for cca 175 spark and hadoop developer certification exam and in the related fields of cloudera hadoop developer certification exam.

    cca 175 certification

    cloudera hadoop developer certification

    cca 175 spark and hadoop developer certification

    hadoop developer certification



    ReplyDelete
  34. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Salesforce training in Chennai | salesforce course in Chennai

    ReplyDelete
  35. Nowadays, most of the businesses rely on cloud based CRM tool to power their business process. They want to access the business from anywhere and anytime. In such scenarios, salesforce CRM will ensure massive advantage to the business owners.
    Regards,
    cloud training in chennai|cloud computing training chennai|cloud computing training in chennai

    ReplyDelete
  36. Everyone wants to get unique place in the IT industry’s for that you need to upgrade your skills, your blog helps me improvise my skill set to get good career, keep sharing your thoughts with us.
    Salesforce Training|Salesforce Training institutes in Chennai|Salesforce Course in Chennai

    ReplyDelete
  37. Thanks for your valuable post ofHadoop Online Training is very informaive and useful for who wants to learn about Hadoop

    Visit :http://www.trainingbees.com/

    ReplyDelete
  38. It is really nice to see the best blog for hadoop tutorials here.Thanks for every thing which has been shared by you. It helped us to build our knowledge on Big Data-Hadoop online training

    Visit : http://trainingbees.com/ViewCoursesN.aspx/BIGDATA-HADOOP

    ReplyDelete
  39. Hello.
    Nice stuff you have shared on Tableau on Hadoop and I really like it. Thanks for sharing.

    Rickybroad

    ReplyDelete
  40. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    mongoDB training in chennai

    ReplyDelete
  41. Thanks for sharing this unique and informative content which provided me the required information.
    oracle apps training in chennai

    ReplyDelete
  42. Enpersol offers Tableau Consulting Services, specializing in implementation and dashboarding in pune and indore. also help you, whether you're just starting out with Tableau, or you need some advanced expertise.

    ReplyDelete
  43. best job oriented big data hadoop online training and Certification

    Course and become Expert in big data hadoop . ...

    ReplyDelete
  44. Enpersol offers Best Tableau Services, specializing in implementation and dashboarding in pune and indore. We are Best Tableau consultants in India.

    ReplyDelete
  45. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  46. This blog contains many lessons. Hope you create more meaningful blogs. Thanks!!! Tableau Online course Bangalore

    ReplyDelete