Skip to content

Instantly share code, notes, and snippets.

@hiroyuki-sato
hiroyuki-sato / ransac.md
Last active July 15, 2021 10:19
cloud compare ransac

\ を削除して行を連結してください。(Windowsの場合)

-O 入力ファイル名 \
-SAVE_CLOUDS FILE 出力ファイル名.bin \
-RANSAC ENABLE_PRIMITIVE PLANE CYLINDER CONE TORUS \
        SUPPORT_POINTS 10000 \
 EPSILON_PERCENTAGE_OF_SCALE 0.072 \
@hiroyuki-sato
hiroyuki-sato / embulk.md
Last active June 16, 2021 09:13
embulk dependencies example

ロックファイルのあるべき姿

build.gradleが適切に設定されていれば、以下の行が含まれているはず

javax.validation:validation-api:1.1.0.Final
com.fasterxml.jackson.core:jackson-annotations:2.6.7
com.fasterxml.jackson.core:jackson-core:2.6.7
com.fasterxml.jackson.core:jackson-databind:2.6.7
@hiroyuki-sato
hiroyuki-sato / embulk.txt
Created June 15, 2021 13:31
embuk-filter-column compare result
#########################################
# example/add_columns.yml
#########################################
******************************************
* v0.9
******************************************
2021-06-15 22:14:53.363 +0900: Embulk v0.9.23
2021-06-15 22:14:54.719 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
// Adding dependencies on JAXB explicitly.
// JAXB 2.2.11 is chosen here because:
// 1. JDK 8's bundled JAXB is 2.2.8. Better with a closer version while we are on Java 8.
// https://javaee.github.io/jaxb-v2/doc/user-guide/ch02.html#a-2-2-8
// 2. Neither com.sun.xml.bind:jaxb-core:2.2.8 nor com.sun.xml.bind:jaxb-impl:2.2.8 does not exist on Maven Central.
// 3. 2.2.11 looks to be used by the most Java libraries among JAXB 2.2.
// https://mvnrepository.com/artifact/javax.xml.bind/jaxb-api
// https://mvnrepository.com/artifact/com.sun.xml.bind/jaxb-core
// https://mvnrepository.com/artifact/com.sun.xml.bind/jaxb-impl
@hiroyuki-sato
hiroyuki-sato / embulk-output-s3.txt
Last active June 10, 2021 15:51
embulk-output-s3 1.5.0 classes
classpath/aws-java-sdk-core-1.11.271.jar
classpath/aws-java-sdk-kms-1.11.271.jar
classpath/aws-java-sdk-s3-1.11.271.jar
classpath/commons-codec-1.9.jar
classpath/commons-logging-1.2.jar
classpath/embulk-output-s3-1.5.0.jar
classpath/httpclient-4.5.2.jar
classpath/httpcore-4.4.4.jar
classpath/ion-java-1.0.2.jar
classpath/jackson-annotations-2.6.0.jar
@hiroyuki-sato
hiroyuki-sato / embulk.diff
Created June 10, 2021 13:57
aws-java-sdk-s3 1.11.271 -> 1.11.1034
diff --git a/build.gradle b/build.gradle
index 97d8aab..df5d9f7 100755
--- a/build.gradle
+++ b/build.gradle
@@ -40,7 +40,7 @@ dependencies {
compile "javax.validation:validation-api:1.1.0.Final"
//compile "joda-time:joda-time:2.9.2"
- compile "com.amazonaws:aws-java-sdk-s3:1.11.271"
+ compile "com.amazonaws:aws-java-sdk-s3:1.11.1034"
@hiroyuki-sato
hiroyuki-sato / output-s3.txt
Created June 10, 2021 13:27
embulk-output-s3 warning
> Task :compileJava
/path/to/embulk-output-s3/src/main/java/org/embulk/output/S3FileOutputPlugin.java:135: warning: [deprecation] AmazonS3Client(AWSCredentials,ClientConfiguration) in AmazonS3Client has been deprecated
client = new AmazonS3Client(basicAWSCredentials, config);
^
/path/to/embulk-output-s3/src/main/java/org/embulk/output/S3FileOutputPlugin.java:139: warning: [deprecation] AmazonS3Client(ClientConfiguration) in AmazonS3Client has been deprecated
client = new AmazonS3Client(config);
^
/path/to/embulk-output-s3/src/main/java/org/embulk/output/S3FileOutputPlugin.java:143: warning: [deprecation] setEndpoint(String) in AmazonS3Client has been deprecated
client.setEndpoint(task.getEndpoint().get());
^
case PGPPublicKey.RSA_ENCRYPT:
case PGPPublicKey.RSA_GENERAL:
case PGPPublicKey.RSA_SIGN:
case PGPPublicKey.DSA:
case PGPPublicKey.ELGAMAL_ENCRYPT:
case PGPPublicKey.ELGAMAL_GENERAL:
case PGPPublicKey.ECDH:
case PGPPublicKey.ECDSA:
case PGPPublicKey.EDDSA:
default:
@hiroyuki-sato
hiroyuki-sato / embulk.md
Created June 8, 2021 10:44
embulk-input-jdbc error
in:
  type: postgresql
  host: localhost
  user: user
  password: xxxx
  database: embulk_test
  #table: users
  query: select name,,mail from users # duplicate comma
@hiroyuki-sato
hiroyuki-sato / embulk.md
Created June 3, 2021 11:26
embulk-input-mysql error
+--------------+------------+------+-----+---------+-------+
| Field        | Type       | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| name         | text       | YES  |     | NULL    |       |
| name_kana    | text       | YES  |     | NULL    |       |
| mail_address | text       | YES  |     | NULL    |       |
| sex          | text       | YES  |     | NULL    |       |
| age          | bigint(20) | YES  |     | NULL    |       |