sqlcipher decrypt database

sqlcipher: https://github.com/sqlcipher/sqlcipher Open an encrypted database with a string key and a hex key.

Dump an encrypted database encrypted.db to plaintext.db.

Dump many databases

Incoming search terms:how to decrypt sqlciphersqlcipher decrypt databasehow to crack sqlcyphersqlcipher decryptsqlcipher decryptorsqlcipher pragmaLink to this post!

SphinxQL FACET is Awesome

FACET clause. This Sphinx specific extension enables faceted search with subtree optimization. It is capable of returning multiple result sets with a single SQL statement, without the need for complicated multi-queries. FACET clauses should be written at the very end of SELECT statements with spaces between them. FACET {expr_list} [BY {expr_list}] [ORDER BY {expr | … Continue reading “SphinxQL FACET is Awesome”

Infobright 企业版数据导入和数据擦写实验

拿到一个IEE的试用版证书,试了下作为日志存储和计算的方案。统计数据查询就不用测了,ICE试试就能感受出来,比hive反正快了不少。 这里主要还是想测试 INSERT / UPDATE / DELETE。 实验环境的日志系统使用 rsyslog -> flume-ng -> IEE/HDFS. 使用Flume-ng自带的HDFS Sink写HDFS的方案一直很稳定,目录按天分,写脚本预先创建目录、加Hive分区,使用hive进行分析。 但是由于可能对当天数据有统计需求hdfs.rollInterval设的比较小,目前是2分钟,每天都会有大量小文件,hive处理速度十分慢。 Flume-ng 找人写了个简单的入mysql的插件,单加了一个队列,把日志文件切分后按列送进mysql,插件要求数据库insert使用prepare批量处理insert。 Incoming search terms:infobright 企业版Link to this post!

Manually Upgrade CDH 5.2 in CM 5

I was interrupted again when upgrading CDH. HDFS This time, NameNode was not started, I have to bring them up and resume the upgrade progress. I didn’t save any log about NN’s error, stop all HDFS components and ran ‘Upgrade HDFS Metadata‘, then start HDFS.

YARN Next, YARN. I started YARN, and then all … Continue reading “Manually Upgrade CDH 5.2 in CM 5”

PHP ODBC Connect Cloudera Impala and Hive

Environment CentOS 5.5 PHP 5.3.10 (This article also works for PHP 5.3.3 on CentOS 6). Dependencies UnixODBC UnixODBC can be installed from yum repo

I built a unixODBC 2.3.2 from source, installed to /usr/local/unixODBC ODBC Connectors Cloudera offers ODBC libs for both Hive and Impala: http://www.cloudera.com/content/support/en/downloads/connectors/impala/impala-odbc-v2-5-15.html http://www.cloudera.com/content/support/en/downloads/connectors/hive/hive-odbc-v2-5-9.html Follow the install guide on urls above, … Continue reading “PHP ODBC Connect Cloudera Impala and Hive”