Re: ELK_on_Hive

2016-08-15 Thread Sumit Khanna
Well i believe you may have a look at relevant logstash input plugins to intakr data from corr. Hdfs /s3 and output it to some index using elastic search plugin. Kibana follows up easy thenafter.. However..was wondering to experinebt hive table visualizations using pivot or other tools..i dont th

Re: hive session drops tables when restarted

2016-08-09 Thread Sumit Khanna
gives me the same error : Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. . need I edit anything in the hive-site.xml file Thanks, On Tue, Aug 9, 2016 at 8

Re: hive session drops tables when restarted

2016-08-08 Thread Sumit Khanna
and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruc

hive session drops tables when restarted

2016-08-08 Thread Sumit Khanna
Hello, I am facing a weird issue with hive. Initially we had hive configured against the default derby, and hardly select * / raw columns were working for my parquet tables. However, having configured it against mysql metastore db now, the all my queries involving min / max / order by / where et

Re: hue / hive issue with sqlite

2016-08-07 Thread Sumit Khanna
resolved, > > On Sun, Aug 7, 2016 at 4:42 AM, Sumit Khanna > wrote: > >> Hello, >> >> we have hue configured against sqlite as default database. >> >> *queries like select height from students limit 222;* work >> >> but *queries like select max(

Re: hue / hive issue with sqlite

2016-08-07 Thread Sumit Khanna
Any ideas? Please let me know. Thanks, On Sun, Aug 7, 2016 at 2:12 PM, Sumit Khanna wrote: > Hello, > > we have hue configured against sqlite as default database. > > *queries like select height from students limit 222;* work > > but *queries like select max(height)

hue / hive issue with sqlite

2016-08-07 Thread Sumit Khanna
Hello, we have hue configured against sqlite as default database. *queries like select height from students limit 222;* work but *queries like select max(height) from students;* wont. in fact that displays " database is locked " error message. is sqlite / hue and as in not migrating to mysql

Re: parquet decoding exceptions - hue sample data view works fine though

2016-08-05 Thread Sumit Khanna
, Aug 6, 2016 at 10:33 AM, Sumit Khanna wrote: > Hey, > > I am having a parquet dir and a table mounted on it. the table is showing > sample view , via hue fine but a simple query like select * from tablename > gives this error : > > >- Bad status for request TFet

parquet decoding exceptions - hue sample data view works fine though

2016-08-05 Thread Sumit Khanna
Hey, I am having a parquet dir and a table mounted on it. the table is showing sample view , via hue fine but a simple query like select * from tablename gives this error : - Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRo

hive not showing up default database

2016-08-05 Thread Sumit Khanna
Hello, hive is not showing default database. but when I try to create database default, it says default database already exists and throws an error. also, FYI, I have configured metastorage db as mysql. Please help. Thanks, Sumit