utzcoz's perosnal blog

Focus on AOSP, XR, and testing tools.

Working on open-source projects:Robolectric,boringdroid,MaruOS,DigitalisX64,aospbooks

awsredshiftcloud

Transfer Redshift data between regions

Firstly, use aws’s UNLOAD command to save your redshift data to s3. UNLOAD('your select sql statement') TO 's3://bucketname/directory/file_prefix' ACCESS_KEY_ID 'aws_id' SECRET_ACCESS_KEY 'aws_key' ALLOWOVERWRITE ADDQUOTES ESCAPE PARALLEL OFF GZIP MANIFEST Above is just a unload template, just replace s3 location to save files which contains redshift data, aws key id and access key, also select command to select data what will be saved. There are some extra command flags need explained: ALLOWOVERWRITE : The command can override origin existed data. ADDQUOTES : The default delimiter of upload command is pipe symbol,...

·3 min read · Read more →

Recent posts

43 total

Don't use empty space after variable in Android makefile

In Android makefile, we always assign a value to a variable. But if we add one or more empty space after variable value, it may cause some build error. For example, If we want to add a preinstall apk to system, we may use makefile template such as below: LOCAL_PATH := $(call my-dir) include $(CLEAR_VARS) LOCAL_MODULE := LeanbackSampleApp LOCAL_SRC_FILES :=...

aospmakefilebuild-system

Android 6.0 JNI uses long to store pointer address

Android 6.0 JNI uses long to store pointer address, which Android 5.0 JNI use int to store pointer address. In Android 5.0, some system servers use long to store pointer address of native object, which is stored as int. If system servers want to use pass it to native methods, it will force cast long parameter to int, for example...

androidjnindk