Monday, November 30, 2015

[HIVE] Querying hive data dictionary


In of my scripts i need column datatypes but i couldn't get easily from HiveCli (or Beeline). I used a trick to get column names, but datatypes or some other properties need parsing of hive output and it seems quite challening. In this post, i will talk about Hive Server2  metastore and show how to get table's specific properties with queries..

Wednesday, November 25, 2015

[Impala] About "InvalidStorageDescriptorException: Invalid delimiter: 'X' " error


In this post , i will talk about an error we face recently when we query data after loading data from xml file via Beeline. First, we get a generic error but after running query on Impala we get real reason and solved it.

Monday, November 23, 2015

My Presentation about "Oracle Cloud Services - Complete Example " @ Oracle Cloud Day Istanbul, 2015

Hi Everyone,

I am very happy to announce you , sorry i am a bit late :/ , that i had a great  honour to make a presentation about Oracle Cloud at the heart of the my city Istanbul at a great Oracle event .

Wednesday, November 18, 2015

[BigData] HDFS file formats comparison


In this port, i will compare HDFS file formats in Oracle BDA cluster. I will move data from default TEXT format to ORC and Parquet file formats and run aggregation queries in order to obtain file usage gain and performance.

Wednesday, November 11, 2015

[Exadata] How to partition a Table yearly and monthly with respect to DATE T

Hi again,

In this post i am trying to partition a big table in Oracle 11gR2 database in Exadata like this: rows which are earlier than a DATE value (for example Year 2015) must be separeated yearly and rows which are newer must be partitioned by montly. 

For instance:

1,'row1','10/03/2010               to partition              Part_Before_2011
5,'row12','10/08/2010              to partition              Part_Before_2011
3,'row56','01/11/2013              to partition              Part_Before_2014
78,'row4','01/03/2015'             to partition              Part_After_2015
327,'row114','03/06/2015'          to partition              Part_After_20156

Wednesday, November 4, 2015

[NoSQL] How to secure an Oracle NoSQL database


In this post, i will talk about security on oracle NoSQL database and how to add security to an existing topology . After we enable security, pinging or connecting the NoSQL database need credentials.

[NoSQL] Solving "No RMI service for adminX" error on a storage node

I will talk about an error that i see from NoSQL Administrative Console page, says that one of the admin services is not running. The error says "Verification violation: admin[3] No RMI service for admin3: service name=commandService". In this post, i will talk about how to search logs of storage nodes and how to bring up the admin service.