hi: yuo are right now just tnere is a base file 🙂 many thanks ... View more

i have updated , and from hue with hive i can see the changes, but not with apache drill query and the dashboard y have que apache drill doesnt show this rows. ... View more

its ok because i have this "hive.metastore.cache-expire-after": "write" { "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris": "thrift://host:9083", "javax.jdo.option.ConnectionURL": "jdbc:mysql://host/drill", "hive.metastore.warehouse.dir": "/tmp/drill_hive_wh", "fs.default.name": "hdfs://host:8020", "hive.metastore.sasl.enabled": "false", "hive.metastore.cache-ttl-seconds": "110800", "hive.metastore.cache-expire-after": "write" } } the problem is the rows that i have uptaded doesnt appear into the drill query, even in the other "canal", so... any suggestions ... View more

hi: today i execute the manual compactor and i seem it work but what happend now with the other delta files?? it created a base directory but there are alot files i need to delete somenthing??? what is better major o minor compaction?? ALTER TABLE canal_acid COMPACT 'Major' ... View more

it work now like this: first create the table from command line: /usr/hdp/current/phoenix-client/bin ./sqlline.py zookeeperHostname create table test (mykey integer not null primary key, mycolumn varchar); upsert into test values (1,'Hello'); upsert into test values (2,'World!'); select * from test; and from RStudio like this: conn <- dbConnect(drv,"jdbc:phoenix:lnxbig04.cajarural.gcr,lnxbig05.cajarural.gcr,lnxbig06.cajarural.gcr:2181:/hbase-unsecure") query <- paste("select * from test") B <- dbGetQuery(conn, query) dbListTables(conn) ... View more

for (l in list.files("/usr/hdp/current/phoenix-client/")) { .jaddClassPath(paste("/usr/hdp/current/phoenix-client/", l, sep = "")) } for (l in list.files("/usr/hdp/current/hbase-client/lib/")) { .jaddClassPath(paste("/usr/hdp/current/hbase-client/lib/", l, sep = "")) } for (l in list.files("/usr/hdp/2.3.2.0-2950/hadoop/lib/")) { .jaddClassPath(paste("/usr/hdp/2.3.2.0-2950/hadoop/lib/", l, sep = "")) } for (l in list.files("/etc/hbase/2.4.0.0-169/0/")) { .jaddClassPath(paste("/etc/hbase/2.4.0.0-169/0/", l, sep = "")) } ... View more