Skip to content
Latest:
  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

Script(s)

technology as-is

  • Home
  • About
  • Archives by Month/Year
  • Contact Me

featured

Error Messages featured Sqoop 

SQOOP : mapred.FileAlreadyExistsException : Output directory

December 3, 2017December 3, 2017 gchandra 0 Comments Hadoop, hive, Import, SQLServer, sqoop

Sometimes when you import data from RDBMS to Hadoop via Sqoop you will see this error. org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory hdfs://hadoopcluster/user/username/importtable 

Read more
featured Linux 

Linux : Compress entire folder to .gz or .bz2

August 28, 2015December 3, 2017 gchandra 0 Comments bzip2, compress, featured, folder, gzip, tar

gzip / bzip2 can compress individual files. To compress entire folder structure ‘tar’ command comes to our rescue. Compress to

Read more
featured Linux 

Error : bash: 08: value too great for base (error token is “08”)

August 17, 2015February 11, 2018 gchandra 0 Comments base, Bash, error token, featured, Linux, octal

Error Message : bash: 08: value too great for base (error token is “08”)  or  bash: 09: value too great

Read more
featured SQL Server Tips and Tricks 

SQLServer : Get Last Businessday of previous month

September 4, 2014February 11, 2018 gchandra 0 Comments featured

DECLARE @LastmonLastBusinessDay date, @inputdate date SET @inputdate = ’05/25/2014′ SELECT @LastmonLastBusinessDay = DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0)) – CASE DATENAME(dw,DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0))) WHEN ‘SUNDAY’ THEN 2

Read more
featured Hadoop Linux OS 

Special or Random characters on PuTTy screen

August 12, 2014December 3, 2017 gchandra 0 Comments Caffeine, featured, PuTTy, Screen Saver, Special Character, Windows Lock

Recently I have been noticing some weird special characters on my PuTTy screen.  There was no pattern to it. It

Read more
featured Tips and Tricks Windows Windows 7 

How to kill or terminate a frozen windows task manager

March 17, 2014December 3, 2017 gchandra 0 Comments featured

Here is a simple command line statement to kill frozen windows task manager. START – RUN – CMD (make sure

Read more
featured SQL Server Tips and Tricks 

SQLServer Delete Duplicate Rows

August 12, 2013December 3, 2017 gchandra 0 Comments CTE, Delete, Duplicate Rows, featured, SQLServer

Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order

Read more

Subscribe to new Script(s)

Enter your email address to subscribe to this site and receive notifications of new posts by email.

Bragging

  • Classes I teach
  • Professional Connections
  • Rate My Professor
  • Rowan – TAP
  • Volunteer Spotlight – TechGirlz

Links

  • Oviam Hosting

Recent Scripts

  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

RSS Script(s)

  • Machine Learning made simple for beginners

Script Categories

  • Database (35)
    • Access (1)
    • MYSQL (7)
    • neo4j (1)
    • SQL Server (14)
      • Active Directory (1)
    • SQLite (2)
    • SSIS (3)
  • Error Messages (6)
  • Exception (2)
  • featured (7)
  • Hadoop (12)
    • Hive (7)
    • Spark (2)
    • Sqoop (2)
  • Interview Qn (1)
  • Machine Learning (1)
  • Misc (4)
    • Audio Conversion (2)
    • Audio Ripping (2)
    • Mp3 (2)
  • OS (26)
    • Docker (3)
    • Linux (11)
    • Mac (1)
    • Windows (12)
      • Vista (3)
      • Windows 7 (1)
  • Scripting (13)
    • Enterprise Library (1)
    • JSON (1)
    • LDAP (1)
    • Ports (1)
    • Python (4)
    • R (1)
    • skmmenu (4)
    • SMTP (1)
  • Software Development (1)
  • Softwares (31)
    • Freebies (4)
    • Open Source (4)
    • Outlook (1)
    • Team Foundation Server (2)
    • Third Party Tools (6)
      • Atalasoft DotImage 4.0 (2)
      • controls (4)
    • Tools (10)
    • Visual Studio (10)
  • Tips and Tricks (36)
  • Tutorial (1)
  • Web (74)
    • AJAX (2)
    • Asp.Net (29)
    • Browser (2)
    • Browsers (4)
    • IIS (2)
    • Javascript (2)
    • Web Coding (42)
    • WebService (1)
    • Wordpress (6)

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?

Tech GirlZ (SQL)

Tech Girlz

Tech Women (BigData)

Feedburner Stats

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?
Copyright © 2022 Script(s). All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.