Skip to content

Instantly share code, notes, and snippets.

View takezoe's full-sized avatar

Naoki Takezoe takezoe

598 followers · 14 following
View GitHub Profile
@takezoe
takezoe / SubqueryToCteRewriter.scala
Last active May 24, 2025 17:30
Simple utility to rewrite duplicated subqueries to CTE
package io.github.takezoe.cte
import wvlet.airframe.sql.model.Expression.UnquotedIdentifier
import wvlet.airframe.sql.model.LogicalPlan
import wvlet.airframe.sql.model.LogicalPlan._
import wvlet.airframe.sql.parser.SQLParser.{parse => parseSQL}
import wvlet.airframe.sql.parser.SQLGenerator.{print => toSQL}
// Simple utility to rewrite duplicated subqueries to CTE.
//
@takezoe
takezoe / RowChecksumFunction.java
Created February 25, 2024 17:05
Trino UDF for generating row-level checksum
package io.trino.operator.scalar;
import com.google.common.collect.ImmutableList;
import io.airlift.slice.Slice;
import io.airlift.slice.Slices;
import io.trino.annotation.UsedByGeneratedCode;
import io.trino.metadata.SqlScalarFunction;
import io.trino.spi.block.Block;
import io.trino.spi.block.SqlRow;
import io.trino.spi.function.BoundSignature;
@takezoe
takezoe / jupyter_on_docker.md
Last active April 29, 2023 05:50
Run JupyterLab on Docker

Run JupyterLab on docker

https://hub.docker.com/r/jupyter/scipy-notebook/

$ docker pull jupyter/scipy-notebook

$ docker run -v `pwd`:/home/jovyan/work -p 10000:8888 --name jupyter jupyter/scipy-notebook
...
 To access the server, open this file in a browser:
@takezoe
takezoe / vscode_metals.md
Last active March 12, 2022 00:35
Keyboard shortcuts in VSCode + Metals

VS Code shortcut in VSCode + Metals

Shorcut Description
CTRL + SPACE Code Completion
COMMAND + P Find File
COMMAND + SHIFT + P Command Pallete
COMMAND + T Find Symbol in Workspace
SHIFT + COMMAND + O Find Symbol in Editor
F12 Go to Definition
@takezoe
takezoe / trino_test.rb
Created May 7, 2021 16:38
Test program for trino-client-ruby using tiny-presto which is library to launch Trino/Presto using docker
require 'trino-client'
require 'tiny-presto'
client = Trino::Client.new(server: 'localhost:8080', catalog: 'memory', user: 'test-user', schema: 'default')
cluster = TinyPresto::Cluster.new('trinodb/trino', '355')
container = cluster.run
loop do
begin
# Make sure to all workers are available.
client.run('show schemas')
@takezoe
takezoe / build.yml
Last active January 23, 2021 16:16
GitHub Actions configuration for GitBucket plugins
name: build
on: [push, pull_request]
jobs:
build:
runs-on: ubuntu-latest
strategy:
matrix:
java: [8, 11]
@takezoe
takezoe / test.svg
Created October 20, 2019 08:26
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@takezoe
takezoe / CyclicDependency.scala
Last active August 27, 2020 00:34
trait CyclicA {
val b = bind[CyclicB]
}
trait CyclicB {
val a = bind[CyclicA]
}
val d = Design.newDesign
d.build[CyclicA] { a =>
@takezoe
takezoe / Hello_PredictionIO.md
Last active March 4, 2019 05:43

Hello Apache PredictionIO!

Start event server:

$ pio eventserver &
@takezoe
takezoe / scalatra-remove-joda.diff
Last active November 23, 2018 01:27
Additional fix for https://github.com/shimamoto/scalatra/commit/8f419ca8145ff858ff4c0a41d5ff80d410972bed
diff --git a/swagger/src/main/scala/org/scalatra/swagger/Swagger.scala b/swagger/src/main/scala/org/scalatra/swagger/Swagger.scala
index 97e00e46..f5525ca2 100644
--- a/swagger/src/main/scala/org/scalatra/swagger/Swagger.scala
+++ b/swagger/src/main/scala/org/scalatra/swagger/Swagger.scala
@@ -45,16 +45,6 @@ trait SwaggerEngine[T <: SwaggerApi[_]] {
object Swagger {
- val excludes: Set[java.lang.reflect.Type] = Set(
- classOf[java.util.TimeZone],