HOOBS | Connect over 2,000 Accessories

I'm changing the column position of my DF, because I will put it into Cassandra. The problems is that I have more that 22 columns and I get this error:

:1: error: too many elements for tuple: 38, allowed: 22

I am using this procedure:

scala> val columns: Array[String] = firstDF.columns

I have a problem with a table in Cassandra.

I have a problems with a table in cassandra. Below is what I did:

CREATE KEYSPACE tfm WITH REPLICATION = {'class': 'SimpleStrategy', 'replication_factor': 1 };

I'm working in one machine.

CREATE TABLE tfm.foehis(hocpny text, hocol text,honumr text,holinh text,hodtto text,hotour text,hoclic text, hooe text,hotpac text,hodtac text,hohrac text,hodesf text,hocdan text,hocdrs text,hocdsl text, hoobs text,hotdsc text,honrac text,holinr text,housca text,hodtea text,hohrea text,housea text,hodtcl text,hohrcl text,houscl text,hodtrc text,hohrrc text,housrc text,hodtra text,hohrra text,housra text,hodtcm text,hohrcm text,houscm text,hodtua text,hohrua text,houser text, PRIMARY KEY((hooe,hodtac,hohrac),hoclic));

Until this point everything is OK. But when I try to do some select queries, I get warnings and errors:

cqlsh> select count(*) from tfm.foehis;

count

-------

56980

(1 rows)

Warnings : Aggregation query used without partition key

Read 100 live rows and 1055 tombstone cells for query SELECT * FROM tfm.foehis LIMIT 100 (see tombstone_warn_threshold)

Read 100 live rows and 1066 tombstone cells for query SELECT * FROM tfm.foehis WHERE token(hooe, hodtac, hohrac) >= token(1045161613, 20180502, 2304) LIMIT 100 (see tombstone_warn_threshold)

cqlsh> select count(*) from tfm.foehis where hoclic=1011;

InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid INTEGER constant (1011) for "hoclic" of type text"

cqlsh> select count(*) from tfm.foehis where hotpac=ANOE;

SyntaxException: line 1:49 no viable alternative at input ';' (...from tfm.foehis where hotpac=[ANOE];)

I supposed that the problems is in the definition of table, but I don't know where the problems is.