Skip to content

Instantly share code, notes, and snippets.

View kzhangkzhang's full-sized avatar

Kevin Zhang kzhangkzhang

13 followers · 34 following
View GitHub Profile
@kzhangkzhang
kzhangkzhang / PerformanceTuning_CheatSheet.md
Last active March 7, 2024 20:20
Oracle SQL Performance Tuning Cheatsheet
@kzhangkzhang
kzhangkzhang / Python_CheatSheet.md
Last active January 3, 2024 20:42
Python Cheat Sheet

Python Cheat Sheet

Support/Big Data/Document/My Docs/Python/Python_CheatSheet.MD

Installation/Config

PIP

-- list all installed packages
@kzhangkzhang
kzhangkzhang / General_RegExpr_CheatSheet
Created September 12, 2019 15:35
Regular Expression
# Regular Expression Cheat Sheet
## Resource
[regexr.com](https://regexr.com)
@kzhangkzhang
kzhangkzhang / General_Markdown_CheatSheet.md
Last active June 30, 2020 21:51

Markdown Cheat Sheet

WebDev\KevinPractice\Youtube\TraversyMedia\026_Markdown_CrashCourse

Heading 1

@kzhangkzhang
kzhangkzhang / APEX_CheatSheet.md
Last active October 2, 2023 19:01

Oracle APEX Cheat Sheet

Support\APEX\APEX_CheatSheet.md

ORDS

How to check APEX version?

http://myapexserver.mycompany.com:8087/i/apex_version.txt -- result Application
@kzhangkzhang
kzhangkzhang / WEB_Javascript_B.md
Last active February 22, 2024 20:50
Modern Javascript (ES6) cheat sheet part B

Modern JavaScript Cheat Sheet - Part B

Support\Web_Cloud\WEB_Javascript_B.md

Classes and Modules

Class Basics

- using CamelCase convention for naming class
  • first letter is UPPERCASE
@kzhangkzhang
kzhangkzhang / WEB_Javascript_A.md
Last active February 22, 2024 20:49
Cheat sheet for modern (ES6) Javascript, part A

Modern JavaScript Cheat Sheet - Part A

Support\Web_Cloud\WEB_Javascript_A.md

Constant

  • Constant must be initialized and value can't be changed (for primitive type)
  • By convention, constant variable shuold be UPPERCASE



  


  




    


          
    

      

        
        

          

              @kzhangkzhang
          

          

            
                kzhangkzhang
                / BIGDATA_Python_ETL.md
            
            

              Last active
              October 10, 2019 17:47
            

              
                Python script example for Big Data ETL
              
          

        

      

        

  

      

    
Python for Big Data ETL


Example 1 - transfer XML data file to CSV data file


    

  • 

    Python version: 2.x, 3.x
    

    • 

  • 

    Sample input data: Tags.xml
    

    • 



    <?xml version="1.0" encoding="utf-8"?>




  


  




    


          
    

      

        
        

          

              @kzhangkzhang
          

          

            
                kzhangkzhang
                / BIGDATA_Pig.md
            
            

              Last active
              October 9, 2019 13:36
            

              
                Cheat Sheet for Big Data Pig Programming & Pig Latin
              
          

        

      

        

  

      

    
Apache Pig Cheatsheet


Example Script


Example 1: Load data file into HDFS


Example source: Take Ctl of Your BigData with Hue in Cloudera CDH (Xavier Morera, PluralSight)


mytags = LOAD 'stackexchange/tags-no-header.csv' USING PigStorage(',') as (Id,TagName,CountTags:int,ExcerptPostId,WikiPostId);




  


  




    


          
    

      

        
        

          

              @kzhangkzhang
          

          

            
                kzhangkzhang
                / BIGDATA_HIVE_Syntax.md
            
            

              Last active
              April 13, 2024 03:27
            

              
                Hive Syntax Cheat Sheet
              
          

        

      

        

  

      

    
Big Data Cheat Sheet


Support\Big Data\BigData_CheatSheet.md


HDFS


-- list files in HDFS
hadoop fs -ls <PATH_OF_DIRECTORY>