@Constantin Stanca Were you able to run any query against that table, e.g. SELECT anything from TableName LIMIT 1? Yes It works doing hive> select id from pns_fr_bench.core limit 1;
OKID-SPP-100-6qN1vlZ4cMaobNIkrscKaB2lBiDkCYWmSqewVNe7PZA
fetched: 1 row(s)hive> I expected to see TABLEPROPERTIES and SERDEPROPERTIES in the table definition. Sorry 🙂 serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.cassandra.serde.cql.CqlSerDe, parameters:{cassandra.cf.name=core, cassandra.columns.mapping=ise,birthd,civility,creatd,dispname,email,fname,haddr,hcity,hcountry,hfax,hphone,hzip,ia,iainst,interest,lname,marketpref,modd,mphone,mrgdate,mrgstat,mrgusrt,msisdn,mtac,ndip,ndrtc,oaddr,ocity,ocountry,ofax,oidval,om,ophone,ozip,poid,preflang,rollbend,usrlvl, serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:{cassandra.ks.password=JV<w7.JzNF3i, cassandra.cf.name=core, EXTERNAL=TRUE, transient_lastDdlTime=1448372689, cassandra.ks.username=run_all_read_bench, storage_handler=org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler, cassandra.ks.name=pns_fr_bench}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE) # Detailed Table Information
Database: pns_fr_bench
Owner: pns
CreateTime: Tue Nov 24 14:44:49 CET 2015
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://master01.net:8020/app/data/pns_fr_bench.db/core
Table Type: EXTERNAL_TABLE
Table Parameters:
EXTERNAL TRUE
cassandra.cf.name core
cassandra.ks.name pns_fr_bench
cassandra.ks.username read_user
storage_handler org.apache.hadoop.hive.cassandra.cql.CqlStorageHandler
transient_lastDdlTime 1448372689
... View more
