Multiplying two positive numbers resulting in a negative number
Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its
Read more
Import CSV to Sqlite DB from Commandline
SQlite Import from commandline Sqlite is an amazingly powerful cute little database, which comes in handy when processing standalone jobs.
Read more
Data Science today :: Where do you or your skill fit in ?
Data Science and developers. In today’s data science mania, here is a quick view of how data is moved from
Read more
Best way to Export Hive table to CSV file
This post is to explain different options available to export Hive Table (ORC, Parquet or Text) to CSV File. Expected
Read more
MySQL – Select statement parsing order
To write better MySQL queries, its important to know the parsing order of Select statement. The order is as follows.
Read more
How to fix curl errors in R
If you encounter “curl” error when installing any packages in “R”, follow these steps Install libcurl-devel $ sudo yum install
Read moreGet Public IP of linux box via ssh
To get public IP (not local IP) of remote linux box, use the following command. $ wget -qO- http://ipecho.net/plain |
Read more
The system administrator has set policies to prevent this installation
This is a common problem when you try to install .msi files on Windows Server. There is a simple way
Read moreIterate files in folder using Spark Scala
This script loops through hdfs files system and reads the first line and writes it to console. Most part its
Read moreSpark Scala Command line Arguments
Its pretty straight forward to add Command Line Arguments to Spark (scala) from shell. $ ./spark-2.0.0-bin-hadoop2.6/bin/spark-shell -i ~/scalaparam.scala –conf spark.driver.args=”param1value
Read more
MySQL client ran out of memory
Error Message : Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran
Read more