IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

On the importance to have good Hive statistics on your tables

Posted on March 23, 2020, updated on March 20, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • The problematic queries
  • Problem has gone with good Hive statistics
  • References

Continue reading

Hadoop Tuning 1 Comment

How to use Livy server to submit Spark job through a REST interface

Posted on February 24, 2020, updated on February 19, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Configuration
  • Curl testing
  • HTTP ERROR: 400
  • Python testing
  • References

Continue reading

Hadoop Administration Leave a comment

Hive concatenate command issues and workaround

Posted on January 24, 2020, updated on January 20, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Concatenate command failing for access right
  • HDFS default access right with Hive and Spark
  • To go further
  • Worked well till...
  • References

Continue reading

Hadoop Administration Leave a comment

How to handle HDFS blocks with corrupted replicas or under replicated

Posted on December 25, 2019, updated on December 20, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Managing under replicated blocks
  • Managing blocks with corrupted replicas
  • References

Continue reading

Hadoop Administration Leave a comment

Hive fetch task really improving response time by bypassing MapReduce ?

Posted on November 24, 2019, updated on February 28, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Identical queries not same response time
  • Partitions statistics and concatenation
  • Fetch task performing worst than MapReduce ?
  • To go further
  • References

Continue reading

Hadoop Tuning Leave a comment

Fetch Zookeeper information from Python with Kazoo to connect Hive

Posted on October 25, 2019, updated on October 22, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Kazoo development environment installation
  • Python source code
  • Kazoo testing
  • References

Continue reading

Hadoop Administration Leave a comment
  • Page 3 of 34
  • « First
  • ‹ Previous
  • 1
  • 2
  • 3(current)
  • 4
  • 5
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (31) Ambari (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (6) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Development (1) Directory Naming (3) Docker (4) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) GATHER_STATS_JOB (1) GoldenGate (3) Grid Control (4) Grub (1) Health Monitor (1) Heat Map (1) High Availability (22) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) Multi-Master Replication Manager (MMM) (1) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (4) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (18) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (26) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (1) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (44) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (21)
  • HPUX (6)
  • Linux (24)
  • mongoDB (1)
  • MySQL (32)
  • Oracle (128)
  • Python (2)
  • SQL Server (3)

Recent Comments

  • Yannick Jaquier on How to identify table fragmentation and remove it ?
  • venkat on How to identify table fragmentation and remove it ?
  • Ravi on Who is locking your accounts (ORA-01017 and ORA-28000 errors) ?
  • MariaDB ColumnStore installation and testing - part 2 on MariaDB ColumnStore installation and testing – part 1
  • MariaDB ColumnStore installation and testing - part 1 on MariaDB ColumnStore installation and testing – part 2

Blogroll

  • Ask Tom
  • Data Virtualizer
  • Exile on Keyboard St. (French)
  • Kevin Closson’s Oracle Blog
  • MySQL Performance Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog
  • The Oracle Instructor

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress