Questions tagged [reindex]
459 questions
1
vote
0 answers
duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" while performing full vacuum on the database
While performing vacuum full, I have received the below highlighted error. Please guide me how to resolve this issue.
/opt/postgres/9.2/bin/psql -p 5433 --username=cmuser cpcm -c "VACUUM
FULL ANALYZE;"
ERROR:
duplicate key value violates…
Raghavendra
- 519
- 1
- 11
- 25
1
vote
2 answers
Reindex sublevel in pandas multiindexed dataframe
I'm trying to reindex a dataframe's multiindex at one sublevel. The df in question looks like this:
test = pd.DataFrame({
'day':[1,3,5],
'position':['A', 'B', 'A'],
'value':[20, 45, 3]
})
test.set_index(['day', 'position'])
>> …
Nico
- 743
- 7
- 19
1
vote
1 answer
Elasticsearch: Set type of field while reindexing? (can it be done with _reindex alone)
Question: Can the Elasticsearch _reindex API be used to set/reset the "field datatypes" of fields that are copied through it?
This question comes from looking at Elastics docs for reindex:…
Mike Lutz
- 1,812
- 1
- 10
- 17
1
vote
1 answer
reindex error - python
I am having some issues with my code anybody know what could be wrong
Code
df=df.groupby(by='store')['transaction_number','transaction_amount'].agg(['count','sum']).reset_index()
Error
ValueError: cannot reindex from a duplicate axis
aiden rosenblatt
- 403
- 2
- 5
- 9
1
vote
0 answers
ES JAVA API not able to updateByQuery when adding sort by an existing field
I want to avoid reindexing all documents after a field mapping being changed from (excerpt from the template file):
"subject": {
"type": "string"
},
to
"subject": {
"type": "string",
"fields": {
…
Luigi Cirillo
- 21
- 5
1
vote
1 answer
Elasticsearch reindex fails with _version error
I'm using Elasticsearch version 5.5.
I have my index A with mapping:
{
"myobj": {
"enabled": false
}
I've created index B with mapping:
{
"myobj": {
"_all": {"enabled": false},
"properties": {
"mykey": {"type": "keyword"}
…
siltalau
- 529
- 3
- 17
1
vote
0 answers
mongodb 3.6 speed up query last records
I have a 30GB mongodb 3.6 collection with 500k documents. the main _id field is a float timestamp (i didnt manually define an index, but inserted on the _id field, assuming from documentation that _id will be used as index and automatically…
user670186
- 2,588
- 6
- 37
- 55
1
vote
2 answers
How to drop datapoints from index
I am new to Python and I have a dataset S2 including dates. When I use the command:
available_datapoints = S2.index,
then
print(available_datapoints)
yields:
[2017-05-07 00:00:00+00:00, ...,…
higuys
- 109
- 5
1
vote
1 answer
Python DataFrame not getting saved. How to permanently assign it?
I assigned the dataframe to itself by reversing its index. But when I call it again, it's showing the old dataframe without reversing it.
apple = apple.reindex(index = apple.index[::-1])
apple.head()
Any help would be appreciated.
Thanks in advance…
saeedar
- 305
- 2
- 19
1
vote
0 answers
How do you reindex Elasticsearch to change the fields of a type?
I've read this the reindex blog and a slew of SO questions on ES re-indexing, but I'm confused about how you reindex an existing index to change the fields of its type. I've indexed a dataset whose fields may change over the course of time. Does…
lingz
- 321
- 3
- 14
1
vote
2 answers
elasticsearch reindex error - reindex from remote
I am trying to reindex from elasticsearch 1.0 to elasticsearch 5.0 directly by using reindex from remote option
Both the versions are installed in the remote system and running on port number 9200 and 9201 respectively.
I have followed the steps of…
Nilanjana
- 121
- 2
- 12
1
vote
1 answer
Pandas Series expand with filling random mean values
I am trying to collect temperature for each hour of the year. After some scrapping, I have almost all temp value by hours but unfortunately, some data was missing and a total number of temp is only 8600 rather than 8783 that year 2016 have as hours.…
Hristo Stoychev
- 405
- 1
- 5
- 13
1
vote
1 answer
SAS Create column of Re-indexed month values based on macro value 12 months back
I have some code that I update each month for work that calculates a number of statistics over the last 12 months of shippment data for a number of different shipment groups i.e. plane, train, truck, ship etc.
In short, I have a column named…
Keith
- 103
- 1
- 9
1
vote
1 answer
Pandas: concatenate and reindex dataframes
I would like to combine two pandas dataframes into a new third dataframe using a new index. Suppose I start with the following:
df = pd.DataFrame(np.ones(25).reshape((5,5)),index = ['A','B','C','D','E'])
df1 =…
trob
- 387
- 1
- 5
- 15
1
vote
4 answers
How to reindex magento2 in xampp?
I am trying to reindex magento2 in my localhost(xampp), but can't reindexing, this message is showing when type in command line, the image is
https://cloudup.com/cJmYZ3Uhkcy
i have also change advanced system setting in my computer, the image…
Nayeem Hyder Riddhi
- 561
- 1
- 6
- 25