qingniufly

    val df = spark.read.text(inputFile)
    df.createOrReplaceTempView("data")

    val query =
      """
        | WITH loglevel AS (SELECT SPLIT(value, ' ')[0] AS level FROM data WHERE LENGTH(value) > 0),
        |      levelcount AS (SELECT level, COUNT(*) as count FROM loglevel GROUP BY level)
        | SELECT level, count FROM levelcount ORDER BY count DESC
      """.stripMargin

qingniufly

shell判断文件,目录是否存在或者具有权限
  #!/bin/sh

Path="/var/log/httpd/"
File="/var/log/httpd/access.log"

#这里的-x 参数判断$Path是否存在并且是否具有可执行权限
if [ ! -x "$Path"]; then
mkdir "$Path"
fi

qingniufly

# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName

qingniufly

package com.komamitsu;

import java.io.IOException;
import java.net.InetSocketAddress;
import java.nio.ByteBuffer;
import java.nio.channels.SelectionKey;
import java.nio.channels.Selector;
import java.nio.channels.ServerSocketChannel;
import java.nio.channels.SocketChannel;
import java.util.Iterator;

qingniufly

First, install the following libraries:

$ brew install unixodbc
$ brew install freetds --with-unixodbc

FreeTDS should already work now, without configuration:

$ tsql -S [IP or hostname] -U [username] -P [password]
locale is "en_US.UTF-8"

locale charset is "UTF-8"