Re: Not working as expected

[Vivek Paranthaman]

Hi Sergey,

It retrieves null in ResultSet...!

Any other solution?

On Wed, Oct 26, 2016 at 6:12 AM, Sergey Soldatov <sergeysolda...@gmail.com>
wrote:

> Hi Vivek,
> You may use meta information for the connection. Once you created
> connection using Phoenix jdbc-driver, you may run following code:
>
> ResultSet rs = 
> connection.meta.getTables(connection.meta.getConnection().getCatalog(), null, 
> "%", new String[] {"TABLE"});
>
> Iterating over the result set you may get table name ("TABLE_NAME") and
> schema ("TABLE_SCHEM") values.
>
> Thanks,
> Sergey
> On Tue, Oct 25, 2016 at 1:51 AM, Vivek Paranthaman <
> vivek.parantha...@bizruntime.com> wrote:
>
>> Hi,
>>
>> Anybody know, how to get Schema and available tables using jdbc-driver
>> from Hbase?
>>
>
>

Not working as expected

[Vivek Paranthaman]

Hi,

Anybody know, how to get Schema and available tables using jdbc-driver from
Hbase?

Phoenix driver 4.8.1-HBase-1.1, doesn't wrap schema

[Vivek Paranthaman]

Hi,

With Phoenix diriver, and Phoenix connection, I tried to get the metaData,
and it gives me "null".
Is this the behaviour of it, or is it an issue in the Driver?
How is this NoSql(HBase) table/schema being converted to JDBCinstances..!?
Java 1.7 api.

Thanks & Regards,
Vivek

Re: [jira] Vivek Paranthaman shared "PHOENIX-3395: ResultSet .next() throws commons-io exception" with you

[Vivek Paranthaman]

If you look into it,
DeferredFileOutputStream.(ILjava/lang/String;
Ljava/lang/String;Ljava/io/File;)
is seeking for 3 parameterised method, which is not available in the Api -
https://commons.apache.org/proper/commons-io/javadocs/api-2.4/org/apache/commons/io/output/DeferredFileOutputStream.html

On Sat, Oct 22, 2016 at 1:15 PM, Ciureanu Constantin <
ciureanu.constan...@gmail.com> wrote:

> Not sure what ti say, check your apache-commons version, perhaps it's
> picking an older one in the classpath.
>
> În vin., 21 oct. 2016, 09:36 Vivek Paranthaman (JIRA), <j...@apache.org>
> a scris:
>
>> Vivek Paranthaman shared an issue with you
>> 
>>
>>
>>
>> > ResultSet .next() throws commons-io exception
>> > -
>> >
>> > Key: PHOENIX-3395
>> > URL: https://issues.apache.org/jira/browse/PHOENIX-3395
>> > Project: Phoenix
>> >  Issue Type: Bug
>> >Affects Versions: 4.5.1
>> > Environment: java -version: 1.7
>> >Reporter: Vivek Paranthaman
>> >
>> > Exception in thread "main" org.apache.phoenix.exception.PhoenixIOException:
>> java.lang.NoSuchMethodError: org.apache.commons.io.output.D
>> eferredFileOutputStream.(ILjava/lang/String;Ljava/
>> lang/String;Ljava/io/File;)V
>> >   at org.apache.phoenix.util.ServerUtil.parseServerException(Serv
>> erUtil.java:108)
>> >   at org.apache.phoenix.iterate.BaseResultIterators.getIterators(
>> BaseResultIterators.java:553)
>> >   at org.apache.phoenix.iterate.MergeSortResultIterator.getIterat
>> ors(MergeSortResultIterator.java:48)
>> >   at org.apache.phoenix.iterate.MergeSortResultIterator.minIterat
>> or(MergeSortResultIterator.java:84)
>> >   at org.apache.phoenix.iterate.MergeSortResultIterator.next(Merg
>> eSortResultIterator.java:111)
>> >   at org.apache.phoenix.iterate.MergeSortTopNResultIterator.next(
>> MergeSortTopNResultIterator.java:85)
>> >   at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultS
>> et.java:773)
>>
>>  Also shared with
>>   jamestaylor
>>
>>
>>
>> --
>> This message was sent by Atlassian JIRA
>> (v6.3.4#6332)
>>
>

[jira] Vivek Paranthaman shared "PHOENIX-3395: ResultSet .next() throws commons-io exception" with you

[Vivek Paranthaman (JIRA)]

Vivek Paranthaman shared an issue with you




> ResultSet .next() throws commons-io exception
> -
>
> Key: PHOENIX-3395
> URL: https://issues.apache.org/jira/browse/PHOENIX-3395
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.5.1
> Environment: java -version: 1.7
>    Reporter: Vivek Paranthaman
>
> Exception in thread "main" org.apache.phoenix.exception.PhoenixIOException: 
> java.lang.NoSuchMethodError: 
> org.apache.commons.io.output.DeferredFileOutputStream.(ILjava/lang/String;Ljava/lang/String;Ljava/io/File;)V
>   at 
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>   at 
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553)
>   at 
> org.apache.phoenix.iterate.MergeSortResultIterator.getIterators(MergeSortResultIterator.java:48)
>   at 
> org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:84)
>   at 
> org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:111)
>   at 
> org.apache.phoenix.iterate.MergeSortTopNResultIterator.next(MergeSortTopNResultIterator.java:85)
>   at 
> org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:773)

 Also shared with
  jamestaylor



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Re: Scanning big region parallely

[Vivek Paranthaman]

Hi,

How to get the Schema out of Hbase using Phoenix driver?
metadata.getSchemas() produce..
http://stackoverflow.com/questions/40123547/phoenixioexception-nomethodexception-deferredfileoutputstramstring-string-fi

On Thu, Oct 20, 2016 at 11:31 AM, Sanooj Padmakumar 
wrote:

> Hi James,
>
> We are loading data from Phoenix tables into in-memory database. Based on
> the query we are finding the number of phoenix input splits (similar to
> what happens inside phoenix MR) and loads the data into in-memory database
> in parallel. So we are looking for ways to further parallelize the scan of
> a larger region.
>
> As you mentioned phoenix does this for all its queries. Can you please
> provide pointers to the phoenix code where this happens ?
>
> Thanks for the prompt response.
>
> Thanks
> Sanooj Padmakumar
>
> On Wed, Oct 19, 2016 at 11:22 PM, James Taylor 
> wrote:
>
>> Hi Sanooj,
>> I'm not sure what you mean by "loading data in our HBase table into
>> in-memory", but Phoenix queries tables in parallel, even within a region
>> depending on how you've configured statistics and guideposts as described
>> here: http://phoenix.apache.org/update_statistics.html
>>
>> Thanks,
>> James
>>
>>
>> On Wednesday, October 19, 2016, Sanooj Padmakumar 
>> wrote:
>>
>>> Hi All
>>>
>>>
>>> We are are loading data in our HBase table into in-memory. For this we
>>> provide a start row and end row and scan the hbase regions. Is there a way
>>> we can scan a big region in parallel to fasten this whole process ? Any
>>> help/pointers on this will be of great help.
>>>
>>> --
>>> Thanks,
>>> Sanooj Padmakumar
>>>
>>
>
>
> --
> Thanks,
> Sanooj Padmakumar
>

Accessing existing schema, creating schema

[Vivek Paranthaman]

Hi ,

Is there a way to getSchema using Phoenix driver connection, java-apifrom
an existing HBase..?

Thank you,
Vivek Paranthaman