Skip to content

Instantly share code, notes, and snippets.

View hendrysuwanda's full-sized avatar
🏠
Working from home

Hendry Suwanda hendrysuwanda

🏠
Working from home
  • Depok, Jawa Barat - Indonesia
View GitHub Profile
@hendrysuwanda
hendrysuwanda / LaporanTagihan.txt
Created October 5, 2011 09:31 — forked from endymuhardin/LaporanTagihan.txt
Contoh Direct Print dengan Java
LAPORAN DAFTAR PELUNASAN KOLETKOR
AGEN PT. ARTIVISI INTERMEDIA
=====================================================================================================================
KODE KOLEKTOR : 0001
NAMA KOLEKTOR : JOJO
+------+--------------+---------------------------+---------+-------------+-------------+-------------+-------------+
@hendrysuwanda
hendrysuwanda / LaporanTagihan.txt
Created October 5, 2011 11:23 — forked from endymuhardin/LaporanTagihan.txt
Contoh Direct Print dengan Java
LAPORAN DAFTAR PELUNASAN KOLETKOR
AGEN PT. ARTIVISI INTERMEDIA
=====================================================================================================================
KODE KOLEKTOR : 0001
NAMA KOLEKTOR : JOJO
+------+--------------+---------------------------+---------+-------------+-------------+-------------+-------------+
@hendrysuwanda
hendrysuwanda / SparkCopyPostgres.scala
Created December 10, 2016 09:42 — forked from longcao/SparkCopyPostgres.scala
COPY Spark DataFrame rows to PostgreSQL (via JDBC)
import java.io.InputStream
import org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils
import org.apache.spark.sql.{ DataFrame, Row }
import org.postgresql.copy.CopyManager
import org.postgresql.core.BaseConnection
val jdbcUrl = s"jdbc:postgresql://..." // db credentials elided
val connectionProperties = {
>>> import os
>>> import sys
>>> os.path.dirname(sys.executable)
'C:\\Python25'
@hendrysuwanda
hendrysuwanda / print_an_array_using_lambda_exp.java
Created September 15, 2017 08:59
How to using java's lambda expression to print an array
Arrays.stream(values).forEach(i -> System.out.println(Integer.toUnsignedString(i, 16)));
Arrays.stream(values)
.mapToObj(i -> Integer.toUnsignedString(i, 16))
.forEach(System.out::println);
String[] nums = {"three","two","one"};
Arrays.stream(nums).forEach(num -> System.out.println(num));
IntStream.of(values)
@hendrysuwanda
hendrysuwanda / oracle_generate_date_between_2_date_ranges.sql
Last active September 15, 2017 12:42
how to generating dates between two date ranges (ex: from 20-Mar-2015 until 20-Apr-2015)
select to_date('20032015','ddMMyyyy') + rownum -1 price_date
from all_objects
where rownum <= to_date('20042015','ddMMyyyy')-to_date('20032015','ddMMyyyy')+1
static class Reader
{
final private int BUFFER_SIZE = 1 << 16;
private DataInputStream din;
private byte[] buffer;
private int bufferPointer, bytesRead;
public Reader()
{
din = new DataInputStream(System.in);
@hendrysuwanda
hendrysuwanda / simple_hive_query_consume_huge_yarn_resources.md
Last active May 3, 2018 04:35
Why this simple hive query consume huge yarn resource

This is not partition table

Query

select * from lyr1_raw.CI_CUSTMAST_HS;

Total Record

11.957.465

Format File

Avro