Re: Undefined column. columnName=IS_ROW_TIMESTAMP

2016-04-13 Thread Pindi, Srinivas
Yes. On Apr 13, 2016, at 5:26 PM, Samarth Jain > wrote: Srinivas, Are you trying to create a phoenix view over an existing HBase table? On Wed, Apr 13, 2016 at 11:47 AM, Pindi, Srinivas

Re: Undefined column. columnName=IS_ROW_TIMESTAMP

2016-04-13 Thread Samarth Jain
Srinivas, Are you trying to create a phoenix view over an existing HBase table? On Wed, Apr 13, 2016 at 11:47 AM, Pindi, Srinivas < srinivas.pi...@epsilon.com> wrote: > *Problem* *Statement*: > > While we are trying to create a phoenix view and we are getting the > following exception. > > > >

Apache Phoenix + Wildfly 10

2016-04-13 Thread marks1900-post01
I am working on integrating Widlfly 10 and Apache Phoenix, and while the following seems to work, though it would be great if someone could give me feedback. I have been using the instructions as outlined here as inspiration:   https://docs.jboss.org/author/display/TEIID/Phoenix+Data+Sources

Re: Flashback queries support in select statement

2016-04-13 Thread James Taylor
Hi Kannan, The only mechanism available is the one you mentioned: https://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API FWIW, opening a new connection is only creating a few Java objects, so there's no real overhead in just opening a new

RE: Flashback queries support in select statement

2016-04-13 Thread kannan.ramanathan
Any help? From: Ramanathan, Kannan: IT (NYK) Sent: Wednesday, April 13, 2016 15:19 To: user@phoenix.apache.org Subject: Flashback queries support in select statement Hi, Is flashback query (queries to look at the state of a record in the past) supported in select statement? I understand it can

Undefined column. columnName=IS_ROW_TIMESTAMP

2016-04-13 Thread Pindi, Srinivas
Problem Statement: While we are trying to create a phoenix view and we are getting the following exception. When I looked at the source code here is what I found: if (currentServerSideTableTimeStamp < MetaDataProtocol.MIN_SYSTEM_TABLE_TIMESTAMP_4_6_0) { columnsToAdd +=

Re: apache phoenix json api

2016-04-13 Thread Josh Elser
For reference materials: definitely check out https://calcite.apache.org/avatica/ While JSON is easy to get started with, there are zero guarantees on compatibility between versions. If you use protobuf, we should be able to hide all schema drift from you as a client (e.g. applications you

Using transaction in custom coprocessor

2016-04-13 Thread Mohammad Adnan Raza
Hello everyone, I have requirement to use transaction in my project. My requirement is - a client starts transaction and do some upsert operation. I'll have a coprocessor that will do few more puts. Now what I want is all these operation should go in single transaction. Meaning if client

Re: apache phoenix json api

2016-04-13 Thread F21
I am currently building a golang client as well, so I've been looking the api over the last few weeks. I am not sure about the decision to have to create a statement first, but in terms of go, it fits the sql package very well, where statements are opened and closed. I don't think there are

Re: apache phoenix json api

2016-04-13 Thread F21
Your PrepareAndExecute request is missing a statementId: https://calcite.apache.org/docs/avatica_json_reference.html#prepareandexecuterequest Before calling PrepareAndExecute, you need to send a CreateStatement request to the server so that it can give you a statementId. Then, use that

apache phoenix json api

2016-04-13 Thread Plamen Paskov
Hi guys, I just setup apache phoenix 4.7 and set the serialization to JSON. Now i'm trying to run a select statement but what i receive is this: { "response": "executeResults", "missingStatement": true, "rpcMetadata": { "response": "rpcMetadata", "serverAddress":