Re: Get multiple version of hbase column using drill

Jince, Currently, it is not possible to query multiple versions of a Cell in HBase tables using Drill. Could you please describe your use case and what is the format of output you expect? aditya... On Mon, Aug 29, 2016 at 12:22 AM, Jince James wrote: > Hi there, > > > I am wondering how to g

Get multiple version of hbase column using drill

Hi there, I am wondering how to get multiple versions[Timestamps?] of a column in hbase using drill. In hbase I am able to achieve this using get 'logData','rpm1472191794',{COLUMNS => ['derivatives','readings'],VERSIONS => 10} I am not able to get all the versions of the column in drill, and

Question related to escaping in create table as for CSV

*Input csv (filename: input.csv):* "Id","customer_id__c","first_name__c","last_name__c","email__c","address__c","city__c","state__c","zipcode__c","careOf__c" "a1T41004uG6EAI",1.0,"George","Washington","gwashing...@usa.gov","3200 Mt Vernon Hwy","Mount Vernon","VA",22121.0,"!@Satya__ , ()" *c

Speed Up Drill

Hello I am using Drill in Window 10 in embedded mode having latest version (1.7). I am writing one select Query for Sql Server Database. Query is:- SELECT CAST(T1.`ID` AS BIGINT) AS `ID`, CAST(T1.`AttributeID` AS BIGINT) AS `AttributeID`, T1.`String_Value` AS `String_Value`, CAST(T1.`Numeric_V