Member since
05-20-2016
13
Posts
4
Kudos Received
0
Solutions
03-21-2017
05:42 PM
Hi all, what is wrong ? Env. Hdp 2.4 > phoenix
CREATE TABLE TB.TABLE1
(
COL1 VARCHAR(3) NOT NULL
,COL2 VARCHAR(20)
,CONSTRAINT pk PRIMARY KEY (COL1)
)
SELECT T.* FROM (
SELECT * FROM TB.TABLE1
) T
SQL Error [1001] [42I01]: ERROR 1001 (42I01): Undefined column family. familyName=T.null
org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): Undefined column family. familyName=T.null
Thanks,
... View more
Labels:
- Labels:
-
Apache Phoenix
02-27-2017
12:07 PM
We have to read a text file and transfer rows to kafka. TailFile SCHEDULING like following ; Scheduling Strategy => Timer driven Run Schedule => 10 sec ( also we have tried 1 min ) When we stop and start TailFile processor works fine. Nifi does not schedule TailFile job ( maybe all processors ) itself. Where schould be controlled ?
... View more
Labels:
- Labels:
-
Apache NiFi
02-24-2017
04:50 PM
1 Kudo
Our use case ; In some text files coming data from some mission critical applications,these are not click stream data or something like that.
We have to catch every row without data losing.
At the beginning, daily approximately 15,000,000 rows expected. 30,000 rows/minute. Somehow we have to use kafka to store data. Some consumers take data from kafka topics and than write to hbase or phoenix.Here is clear for us. The most important thing is all rows in these text files must be readed anyway. Question 1. Which solution is best practice for that ? 1. Flume & Kafka ? 2. Spark streaming & Kafka ? 3. Only Spark streaming ? 4. Storm & Kafka ? 5. Flume --> to hbase or phoenix ? 6. any other solutions ?
Question 2. Can we use best practice solution with Nifi ?
Thanks in advance,
... View more
Labels:
02-24-2017
10:01 AM
You are right about that. Maven artifact and group id does not work
.phoenix/phoenix-server-client -->
<dependency>
<groupId>org.apache.phoenix</groupId>
<artifactId>phoenix-server-client</artifactId>
<version>4.7.0-HBase-1.1</version>
</dependency>
.
How can be found right phoenix jdbc driver and related jars to connect phoenix using java ?
Is it possibble to connect phoenix in any java application?
... View more
02-23-2017
07:59 PM
1 Kudo
How can be found Phoenix jdbc drivers on maven repository with group and artifact id or direct phoenix_jdbc_bla_bla.jar like ojdbc6.jar oracle jdbc driver ?
Thanks in advance
... View more
Labels:
- Labels:
-
Apache Phoenix