TreasureDataでカラム名に大文字が入ってしまった場合のメモ

SELECT
*
FROM
(TABLE)
LIMIT 1

["v","time"]
[{"id":"hi","time":"1334102460"},1334102460]

{"id":"hi","time":"1334102460"}

# encoding: utf-8
require 'json'

header = JSON.parse(File.read("~.json", :encoding=>"UTF-8"))
db = "dbname"
table = "tablename"
cnt = 0
puts "-- #{db}.#{table}"
puts "SELECT "
header.each_key do |key|
  cnt += 1
  puts "v['#{key}'] AS #{key.downcase},"  if key != 'time' and cnt != header.length
  puts "v['#{key}'] AS #{key.downcase}"   if key != 'time' and cnt == header.length
  puts "#{key} AS #{key.downcase},"       if key == 'time' and cnt != header.length
  puts "#{key} AS #{key.downcase}"        if key == 'time' and cnt == header.length
end
puts "FROM #{table}"

$ td table:swap <db> <スキーマに大文字があるテーブル> <先ほどの結果を出力したテーブル>