International Money transfer from USA

How to find the best international money transfer service from USA for personal or business reason. The website which will give you the details of the best rates available is https://compareremit.com 2. For personal money transfer https://www.riamoneytransfer.com/us/en seems to be generally giving a higher rate may not be the highest but reliable and generally good. … Continue reading International Money transfer from USA

Best low-cost Home Office phone service

Here are some of the good low-cost phone services for homes or home-offices. Ooma TeloSkype 8x8 expressMagicjack Ooma Telo Ooma has been in business over 10 years and have reliable service. They provide a small device called Telo which costs around $70 new (on amazon etc.) or around $30-40 used (ebay etc.). If you are … Continue reading Best low-cost Home Office phone service

How to use Spark, Python, ODBC in VSCode to access Hive/Impala/MySQL/Oracle etc. tables.

Reference: https://kontext.tech/column/spark/290/connect-to-sql-server-in-spark-pyspark#via_odbc_driver_and_pyodbc_package_2 Objective: We want to use Python, Pyspark, Pyodbc to access tables from any ODBC DSN datasource like Hive/Impala/MySQL/Oracle/MSSQL/MongoDB etc. from a Windows laptop. Although these steps are tested on a Windows laptop, similar steps could probably work in MacOS or linux but needs some testing. STEP: Check if pyspark and other dependencies are … Continue reading How to use Spark, Python, ODBC in VSCode to access Hive/Impala/MySQL/Oracle etc. tables.

Install Kudu in Cloudera CDH 5.16

Reference: https://blog.clairvoyantsoft.com/installing-apache-kudu-on-clouderas-quickstart-vm-3bdc202ce142 Apache Kudu is a relational database in the Hadoop ecosystem which provides CRUD update/delete capabilities in Impala tables. It stores data outside of hdfs in tablet files in the hadoop datanodes. It is useful for fast IOT data storage and querying as soon as data is inserted into the table unlike HDFS hive … Continue reading Install Kudu in Cloudera CDH 5.16

Use pyodbc with Cloudera Impala ODBC and Kerberos

Initially tried the python impyla package to connect to Cloudera Impala but ran into various errors and dependency issues. Also 2 of 3 queries would hang or give errors. So next tried pyodbc to connect to Impala. Linux System Requirements: The Cloudera ODBC Driver for Impala is recommended for Impala versions 2.8 through 3.3, and … Continue reading Use pyodbc with Cloudera Impala ODBC and Kerberos