• Home
  • Algorithms
  • Java
  • Hive
  • Learn Java
  • Hadoop
  • OrientDB
  • Database
  • Others
YouTube Twitter RSS
My IT Learnings
Posts related to computer science, algorithms, software development, databases etc
 
Skip to content
  • Home
  • Algorithms
  • Java
  • Hive
  • Learn Java
  • Hadoop
  • OrientDB
  • Database
  • Others
Posts tagged "IN operator"

Tag Archives: IN operator

SQL query with IN operator working SLOW?

rajesh • November 30, 2015database database, IN operator, performance, select, sql
0

Problem Statement :- While working on one of the project, we came across the following requirement:- Given a list of unique IDs, check whether for each ID the data is exactly the same in the database tables of two different systems. For non-matching data dump the unique ID in a…

Continue reading

  • YouTube Twitter RSS
  • Archives

    • August 2016 (3)
    • July 2016 (3)
    • May 2016 (3)
    • April 2016 (2)
    • March 2016 (30)
    • February 2016 (2)
    • January 2016 (5)
    • December 2015 (3)
    • November 2015 (4)
    • October 2015 (6)
  • Categories

    • algorithms (5)
    • bigdata (34)
    • computer science (3)
    • database (7)
    • eclipse (1)
    • hadoop (3)
    • java (8)
    • maven (1)
  • Tags

    algorithms ArrayList base64 bfs bigdata binary search BlockingQueue bucketing complex data type consumer create table database data structures data types eclipse encoding external graph hadoop hdfs hive IN operator insert java jdbc jsch load data maven metastore mysql oracle orc partitioning performance producer remote script select sequencefile sql sqlldr ssh ssh2 stack unicode update
  • Home
  • Algorithms
  • Java
  • Hive
  • Learn Java
  • Hadoop
  • OrientDB
  • Database
  • Others
Powered by Nirvana & WordPress.
YouTube Twitter RSS